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?