I am using MySQL. My root user doesn't have all privileges. How can I get all privileges back to the root user? How to do it step by step?
+1
A:
Log in as root, then run the following MySQL commands:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;
Kaleb Brasee
2009-11-10 15:34:55
ErrorSQL query:GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';MySQL said: Documentation#1045 - Access denied for user 'root'@'localhost' (using password: YES)
Steven
2009-11-10 15:40:51
You were logged in to mysql as root when you ran this, correct?
Kaleb Brasee
2009-11-10 15:47:53
I wonder if you need to set the password as well, and maybe the ability to grant:GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'some_password' GRANT OPTION;
Kaleb Brasee
2009-11-10 15:51:44
Yes, I was logged in to mysql as root when I ran it. I still have my password. When I run,GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY 'my_password' GRANT OPTION; it says I have an error in my SQL syntax.
Steven
2009-11-10 16:11:15