run command folowing 1. service myql stop 2. mysqld_safe --skip-grant-tables 3.mysql --user=root mysql 4. update user set Password=PASSWORD('new-password') where user='root'; flush privileges; exit; 5. service mysql restart6. test login myql -uroot -p7. test login on phpmyadmin
---------------------------------------------------------------- How to reset the root password for mysql:
Stop mysql:
1. service mysql stop
Run mysql with skip grants to be able to login without any password
2. mysqld_safe --skip-grant-tables &
Login as root
3. mysql -u root
4. mysql commands:
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD-HERE") where User='root';
mysql> flush privileges;
mysql> quit
Stop mysql
5. service mysql stop
Start mysql normally:
6. service mysql start
Try to login using your new password:
7. mysql -u root -p