Search throught ALL MYSQL databases in WHM

[fmosse]

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]

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_.

 

[Babene7]

Why not use grep directly?

grep USER /var/lib/mysql/* -Rl

 

[nixuser]

Did you found a solution for this?

 

[fmosse]

No