3

MySQL 5.5 on CentOS 6 -- mysql user 'root@localhost' cannot grant privs

view full story
linux-howto

http://serverfault.com – This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and . I know the password is correct as I can log in with root@localhost to the mysql server and can also create users. However, when I try to grant privileges to the newly created user I get the dreaded "Access denied for user root@localhost (using password: YES)" error message. GRANT ALL PRIVILEGES ON . TO 'myUserName'@'localhost' IDENTIFIED WITH 'myUsersPass' WITH GRANT OPTION; Returns: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) There's got to be something sma (HowTos)