Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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