Ok, I was confused about the password thing. It works now that I'm passing root's password in the command:
/usr/local/mysql/bin/mysqldump --opt --all-databases -prootpassword > /usr/local/mysql/data/mysqldump > You're joking, right? (Perhaps you thought the original question was a > joke, too, as root normally has access to all dbs?) > > 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? > -- 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]