mysql8修改密码问题

查看初始密码:

grep "temporary password" /var/log/mysqld.log

查看validate_password变量

SHOW VARIABLES LIKE 'validate_password%';

修改密码长度:

set global validate_password.length=4;

修改密码策略:

set global validate_password.policy=0;

mysql8修改密码策略:

set global validate_password.policy=0;

validate_password_length变为validate_password.length

修改密码:

alter user 'root'@'localhost' identified by 'root';

原文地址:https://www.cnblogs.com/timlong/p/9323564.html