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
Subject
Written By
Posted
Unable to grant privileges, GRANT command has no effect
November 14, 2013 11:28AM
November 14, 2013 08:14PM
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.