As I understand the manual <http://www.mysql.com/doc/en/GRANT.html>, that will give root access to every db, from every host except localhost, with no password! I can't imagine that's a good idea. And even so, I don't think this will help, as he's connecting from localhost.
If we take the question at face value, it appears he has some dbs that root can't access. (I've never tried it, but I supppose it's possible to revoke root's access to a particular db.) If we assume [EMAIL PROTECTED] has a password we don't want to change, the correct command would be
GRANT ALL ON *.* to [EMAIL PROTECTED];
If he wants to change root's password at the same time, he would need to add the IDENTIFIED BY clause
GRANT ALL ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'newpassword';
Am I missing something?
Michael
Dathan Vance Pattishall wrote:
Look at GRANT on mysql.com
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFITED BY '';
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: Randall Perry [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, November 11, 2003 3:05 PM -->To: [EMAIL PROTECTED] -->Subject: Backing up all databases --> -->Am testing this command to backup databases: --> -->/usr/local/mysql/bin/mysqldump --opt --all-databases > -->/usr/local/mysql/data/mysqldump --> -->Am running as root, but it only backs up databases root has access too. --> -->What's the best way to handle this -- give root full perms on all dbs? --> --> -->-- -->Randall Perry -->sysTame --> -->Xserve Web Hosting/Co-location -->Website Development/Promotion -->Mac Consulting/Sales --> -->http://www.systame.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
