Re: I accidentally revoked all privileges from root user, now unable to login to my mysql server

[Peter Brawley]

Run mysqld --skip-grant-tables, not mysqld_safe.

In the mysql.user table you will want to set all root privs to 'Y'.

Can't provide 5.1 help, it's too long ago and I've no 5.1 installation to help recall.

Quote

- Finally, do you mean that if the server is stopped, then I can be able to make changes in the database through Navicat? [Like 'information-schema' database, 'user_privileges' table]

?! Obviously you cannot change the database whilst the server is stopped.

Do none of this through third-party software. Use the command line to start and stop the server, and the mysal client program as client interfa ce.



Edited 2 time(s). Last edit at 11/23/2018 12:05PM by Peter Brawley.