SHOW VARIABLES LIKE 'validate_password%';
修改mysql配置参数
set global validate_password_policy=0;
set global validate_password_mixed_case_count=0;
set global validate_password_number_count=3;
set global validate_password_special_char_count=0;
set global validate_password_length=3;
SHOW VARIABLES LIKE 'validate_password%';
修改简单密码
use mysql
SET PASSWORD = PASSWORD('123456');
flush privileges;
设置完后重启mysql服务器就可以了