‘strings’ to the rescue
Posted by Sheeri Cabral on Aug 29, 2009
A broken VIEW was caused by the view’s definer being non-existent. In this particular system, backups are done by replicating all the machines (production, development, test, etc) to one server and doing cold physical backups off that server, which currently has 12 instances running.
So in order to find on what machine the user might still be defined, I went to the backup server. All the data directories are in one path, ie:
instance 1 has a datadir of /data/mysql/instance1 instance 2 has a datadir of /data/mysql/instance2
Now, the unix tool strings can be used against many types of files. In particular, though, you can use strings on the mysql/user.MYD file to see the username, host, and password hash. Read the rest of this entry . . .
