Forgot MySQL password, how to break?

1. Single Instance Scenario

Now stop the database

/etc/init.d/mysqld stop

Start the database with the following command

Mysqld_safe --skip-grant-tables --user=mysql &

You can now log in using the MySQL command

Mysql-uroot

And then you can change the password.

Update Mysql.user set Password=password ("password") where user= ' root ' and host= ' localhost ';

2. Multi-instance scenarios

Stop the database first, and then start the database with the following command

/bin/sh/app/mysql/bin/mysqld_safe--defaults-file=/data/3306/my.cnf --skip-grant-tables --user=mysql &

Landing

Mysql-uroot-s Mysql.sock

And then you can change the password.

Mysql>update Mysql.user set Password=password ("password") where user= ' root ' and host= ' localhost ';

Mysql>flush privileges;

This article is from the "Old Warm Man blog" blog, please be sure to keep this source http://ashine.blog.51cto.com/1632639/1654067

Forgot MySQL password, how to break?