View Single Post
  #25  
Old 17th September 2009, 00:27
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 413
Thanks: 75
Thanked 12 Times in 10 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

What I have done to fix it.
Edited the /etc/mysql/my.cnf file. I have added
Quote:
skip-grant-tables
after
Quote:
[mysqld]
. Restarted the mysql server
Quote:
/etc/init.d/mysql restart
I now was able to get into mysql without login and password. I imported the backupped mysql.user table. Deleted the "skip-grant-tables" from the my.cnf file. Rebooted the server and everyting was fine again. Phoeffffff.

Another question now. What should I delete from the mysql.user table. I know now not the whole table.
Reply With Quote