MySQL Privilages Help

Hi, i was messing with MySQL and i've lost my privilages as root, which i can't seem to get back MySQL Privilages Help

If i do the following

# mysql --user=root mysql
mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mypass' WITH GRANT OPTION;

I just get Access denied for user: 'root@localhost' (Using password: NO)

I can't re-add the privilages via phpmyadmin because they no longer show, just a list of the databases.

I've tried to FLUSH PRIVILEGES; but no difference.

How can i add all my privilages back as root?

thanks

 

 

 

 

Top