Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I tried to allow root remote access in MYSQL, I did update host='*" where user='root' and host='localhost'; then restarted the mysql server, now I have not localhost/remote access!! any idea to revert this change? please help thanks!

Edit: resolved I use usr/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking & to bypass grant table that I messed up, then reverted the changes I made.

share|improve this question
What exactly is the error message? And how did you update those information about user and host? – coolwater Oct 16 '09 at 23:05
up vote 2 down vote accepted

You can use the the procedure here to reset your root account. After that, you may want to restore the database named mysql from your recent backup if your changed broke any of the other permissions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.