MySQL - matchings users to dbs?
I'm putting together a new backup script, that stores the daily backups in the user directorys (sorta like Cpanel does it) But I also want to backup the users databases there too.
The problem I'm having, is that I don't know which database is owned by which user. And I'm afraid to experiment with the Grant tables on the live server. (I'm getting ready to move, and my test box is packed away)
Can someone please give me the command to query who owns a particular mysql database?
Thanks in Advance