Ubuntu20.04 配置mysql

1.配置root密码
use mysql;
UPDATE user SET plugin=‘mysql_native_password’ WHERE User=‘root’;

SHOW VARIABLES LIKE ‘validate_password%’;
set global validate_password.policy=LOW;
set global validate_password.length=6;
SET PASSWORD = ‘123456’;
FLUSH PRIVILEGES;

上一篇:mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before


下一篇:mysql 5.7安装密码校验插件validate_password