MySQL multi-instance forgot root password, change password

1. Modify Configuration parameters

/etc/my.cnf

In

[mysqld3306] Add the following:

Skip-grant-tables

2. Restart MySQL

Mysqld_multi Start 3306

3. Change the password

Mysql-h127.0.0.1-p3306-uroot

Update Mysql.user set Password=password (' Test_new2_password ') where user= ' root ';

Flush privileges;

Close the database

Mysqld_multi Stop 3306

or mysqladmin-h127.0.0.1-uroot-p3306-pTest_new2_password shutdown

5. Remove Parameters

[mysqld3306] Remove:

Skip-grant-tables

5. Start

Mysqld_multi Start 3306

MySQL multi-instance forgot root password, change password