Search Suggest

reset password root mysql

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     


Reference site

Đăng nhận xét