Mysql 5.7 忘记root密码或重置密码的详细方法

[root@iZ2ze14tbj23jllo85kuh1Z ~]# vim /etc/my.cnf

skip-grant-tables

[mysqld]
**skip-grant-tables**
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

service mysqld restart

mysql -uroot -p (直接点击回车，密码为空)

use mysql;

update user set password=password('root') where user='root';

update user set authentication_string=password('123456') where user='root';

flush privileges;

quit;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement；

SET PASSWORD = PASSWORD('123456');

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

set global validate_password_policy=0; set global validate_password_mixed_case_count=2;

SET PASSWORD = PASSWORD('123456');