mysql的一些小知识总结

1.Your password does not satisfy the current policy requirements

vim /etc/my.cnf

[mysqld]下添加：
validate_password.length=4;
validate_password.policy=0;

systemctl restart mysqld

2.You must reset your password using ALTER USER statement before executing this statement.

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

3.中文显示乱码

[mysqld]下添加：
character_set_server=utf8

4.查看全局变量

SHOW VARIABLES LIKE 'validate_password%';//密码设置变量
SHOW VARIABLES LIKE "char%";//字符集变量