Search for a specific word in all MySQL databases

fmosse

Well-Known Member
Jan 6, 2002
53
1
308
Hi,

I need to find all the MySQL databases where there is a specific word

How can I do it using WHM Console or WHM PHPMYADMIN?

Thanks,
Francisco
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
10,360
1,632
363
cPanel Access Level
Root Administrator
Hey there! There isn't an easy way to do this through any ready-made tools available with MySQL or cPanel. You'd need to use a custom query executed from the MySQL command prompt to perform this type of work. While I can't provide you with the exact code you need to run, I did find a good tutorial here with helpful information:


Can you try working with that to see if that gets you what you need?