How to reset password in mysql5.7

Mysql5.7 method to reset the password: First execute the [update user set authentication_string = password('123456') where user = 'root';] statement; then restart the mysql service.

Specific method:

(Recommended tutorial:mysql video tutorial)

Close MySQL5. 7 permission system

Find the configuration file my.cnf of MySQL5.7

Edit and add the code skip-grant-tables at the end of the file

Restart the mysqld service and log in to MySQL

$systemctl restart mysqld

When you log in to mysql at this time, you can log in without a password.

Modify root password

$use mysql; $select host,user,authentication_string from user; #修改root密码 $update user set authentication_string = password('123456') where user = 'root';

Enable the permission system, restart MySQL, and log in with a new password

$vim /etc/my.cnf #开启权限系统 #skip-grant-tables #重启mysql $systemctl restart mysqld #新root密码登陆 $mysql -uroot -p

Related recommendations:mysql tutorial

The above is the detailed content of How to reset password in mysql5.7. For more information, please follow other related articles on the PHP Chinese website!