How to Search Your Entire MySQL Database for a Phrase

I tested the following command on an Ubuntu v18.04 virtual private server (VPS).

$ sudo mysqldump -u <username> –no-create-info –extended-insert=FALSE <database name> | grep -i “<search string>”