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

[Vicky Akana]

Hey Peter,


- I had tried stopping with --skip-grant-tables, but I get an error of "option missing". I am using MySQL 5.1.73 (I know still behind), would that option be missing for MySQL 5.1.73?
=> I used following command: "/etc/init.d/mysql stop mysqld_safe --skip-grant-tables"
=> But in my /etc/init.d directory, I didnt find mysql dir, so I ran that command in /etc/init.d dir


- Also, please let me know what you exactly mean by "make desired changes to system tables" cause it seems like those changes are what will solve the issue! [what are those changes?]

- 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]

Thanks