MySQL Forums
Forum List  »  Newbie

Unable to grant privileges, GRANT command has no effect
Posted by: ERIC EVANS
Date: November 14, 2013 11:28AM

I'm trying to add remote access privileges for the MySQL root user. I login to mysql as root, and when I do a SHOW GRANTS I see this:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '437284378' WITH GRANT OPTION

which seems fine. But then I enter this command

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'some_password_string' WITH GRANT OPTION;
FLUSH PRIVILEGES;

It says "Query OK, 0 rows affected (0.00 sec)" Then when I do a SHOW GRANTS again the table is unchanged. I'm a newcomer to MySQL, kind of naive, and I can't see why my GRANT command has no effect. Can someone point out to me what it is that I am overlooking?

(BTW, I checked the my.cnf file and it does not contain a bind command to bind to 127.0.0.1)

Thanks very much,
Eric

Options: ReplyQuote


Subject
Written By
Posted
Unable to grant privileges, GRANT command has no effect
November 14, 2013 11:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.