Search for a specific word in all MySQL databases

[fmosse]

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]

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:

Search through all databases, tables, columns in MySQL | Change Is Inevitable

Dynamic mysql database search, Search find through all databases, all table, all columns in MySQL using a stored procedure.

kedar.nitty-witty.com

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