How to Search Whole MySQL Database for a Particular String

Use this in the Linux terminal command-line to search whole MySQL database for a particular string.

$ mysqldump -pPASSWORD database --extended=FALSE | grep 'string' | less -S

Found this article interesting? Follow Brightwhiz on Facebook, Twitter, and YouTube to read and watch more content we post.