Reset MySQL root password

First of all stop mysql server and run:

mysqld_safe –skip-grant-tables

 

In new console connect to mysql:

mysql –user=root mysql

update user set Password=PASSWORD(‘reseted_password’) where user=’root’;
flush privileges;

Leave a Reply

Your email address will not be published. Required fields are marked *