MySQL 5.7 forgot root password workaround

1. Modify the configuration file

Vim/etc/my.cnf

Add in [MYSQLD] node

Skip-grant-tables

2. Restart MySQL

3. Enter with a blank password

Mysql-uroot

Perform

Update Mysql.user set Authentication_string=password (' 123 ') where user= ' root ' and Host = ' localhost ';

Flush privileges;

Quit MySQL

Restore MY.CNF

Add, use the above method to change the password, when using Mysql-uroot-p < demo.sql import data when the error, so use the following statement to modify the password better

ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘MyNewPass‘;

MySQL 5.7 forgot root password workaround