1. stop all services and instances of MySQL
2. Run
- Code: Select all
sh mysql.server start --skip-grant-tables
3. Now you can access phpmyadmin. Go to 'mysql' schema and try to access the user table. For me, it was broken, so i have needed to repair it. When i look at the repair table, i found bad users that i don't recognize (dev...)
option a
If you are under MAC and use Time machine, you can simply restore files : user.frm, user.MYD and user.MYI. It worked for me.
option b
If root doesn't exist, you can create it. Or in SQL prompt just issue the following command :
- Code: Select all
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;
4. restart mysql and it will be ok to access with root login.
Hope you'll find this usefull.[/list]