Search throught ALL MYSQL databases in WHM

fmosse

Well-Known Member
Jan 6, 2002
54
1
308
Hi, I need a script that search throught ALL MYSQL databases in WHM, inside all wp_users tables, if there is a user with is called "XXXXX"

Is there anyway to do it using WHM CONSOLE or using WHM Root's PhpMyAdmin ?

Thanks,
Francisco
 

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
723
285
363
cPanel Access Level
DataCenter Provider
Anything MySQL related can only work on one database at a time. You could write a script that loops all the tables or use MySQL dump to dump all databases and then use grep/egrep to search that. The other issue is that the table name is going to be SOMETHING_users. It's very easy to install WordPress and change the prefix from wp_ to SOMETHING_.
 
  • Like
Reactions: cPRex