Resetting mysql root password

1.stop mysql

2.mysqld_safe –skip-grant-tables &

3.run mysql and follow the steps

>use mysql

>update user set Password=PASSWORD(‘*****’) WHERE User=’root’;

>flush privileges;

4. stop & start mysql

Leave a comment