Lost grand options in mysql
If the
Found at: http://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-users-full-privileges
GRANT ALL
doesn't work, try:- Stop
mysqld
and restart it with the--skip-grant-tables
option. - Connect to the
mysqld
server with just:mysql
(i.e. no-p
option, and username may not be required). - Issue the following commands in the mysql client:
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
GRANT ALL ON *.* TO 'root'@'localhost';
and have it work.Found at: http://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-users-full-privileges
Comments
Post a Comment