View Single Post
Old 17th September 2009, 01:27
skoena skoena is offline
Senior Member
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 429
Thanks: 78
Thanked 17 Times in 14 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena

What I have done to fix it.
Edited the /etc/mysql/my.cnf file. I have added
. Restarted the mysql server
/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