Search throught ALL MYSQL databases in WHM

fmosse

• July 01, 2022 15:05

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

  • July 02, 2022 01:14

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

  0
• 

  Babene7

  • July 04, 2022 16:44

  Why not use grep directly? grep USER /var/lib/mysql/* -Rl
  

  0
• 

  nixuser

  • August 31, 2022 12:29

  Did you found a solution for this?

  0
• 

  fmosse

  • September 02, 2022 05:02

  No :(

  0

Please sign in to leave a comment.