mysql8.0密码修改

 1.问题:

mysql> alter user 'root'@'%' identified by 'RMM!12345';

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

解决方式: set global validate_password.policy=0;

参考:https://www.cnblogs.com/baby123/p/12221405.html

mysql> set global validate_password.policy=0;

Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'validate_password%';

+--------------------------------------+-------+

| Variable_name                        | Value |

+--------------------------------------+-------+

| validate_password.check_user_name    | ON    |

| validate_password.dictionary_file    |       |

| validate_password.length             | 8     |

| validate_password.mixed_case_count   | 1     |

| validate_password.number_count       | 1     |

| validate_password.policy             | LOW   |

| validate_password.special_char_count | 1     |

+--------------------------------------+-------+

7 rows in set (0.01 sec)

mysql> alter user 'root'@'%' identified by '$new_pass';

Query OK, 0 rows affected (0.06 sec)

2.修改mysql 8.0以上版本的root密码

参考:https://blog.csdn.net/Box_clf/article/details/124599166

-修改/etc/my.cnf

在[mysqld]后加skip-grant-tables

重启mysql: systemctl restart mysqld

-进入无密码进入mysql

mysql

flush privileges;

修改密码为:

 alter user 'root'@'%' identified by '$new_passwd';

 exit

还原之前的skip-grant-tables配置重启