1. Single Instance
Now stop the database
/etc/init.d/mysqld stop
Use the following command to log in
Mysqld_safe--skip-grant-tables--user=mysql &
You can now log in using MySQL
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
Stop the database first, and then start the database with the following command
/bin/sh/application/mysql/bin/mysqld_safe--defaults-file=my.cnf--skip-grant-tables--user=mysql &
Landing
Mysql-uroot-s Mysql.sock
And then you can change the password.
Update Mysql.user set Password=password ("password") where user= ' root ' and host= ' localhost ';
This article is from the "Old Warm Man blog" blog, please be sure to keep this source http://ashine.blog.51cto.com/1632639/1654058
Forgot MySQL password, how to break?