how to change the mysql password for root

1. sudo service mysqld stop

2.mysqld_safe --skip-grant-tables

3.open a new terminal

4.update user set Password=PASSWORD(‘new-password’) WHERE User=’root’; 

No comments:

Post a Comment