MySQL Forums
Forum List  »  Security

Re: I accidentally revoked all privileges from root user, now unable to login to my mysql server
Posted by: Vicky Akana
Date: November 23, 2018 12:46AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I accidentally revoked all privileges from root user, now unable to login to my mysql server
748
November 23, 2018 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.