KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I accidentally removed some of the privileges from my MySQL root user, including the ability to alter tables. Is there some way I can restore this user to its original state (with all privileges)? UPDATE mysql.user SET Grant_priv = 'Y', Super_priv = 'Y' WHERE User = 'root'; # MySQL returned an empty result set (i.e. zero rows). FLUSH PRIVILEGES ; # MySQL returned an empty result set (i.e. zero rows). #1045 - Access denied for user 'root'@'localhost' (using password: YES) GRANT ALL ON *.* TO 'root'@'localhost'
Tags (comma-separated)
Save Edits
Cancel