mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; ERROR 1819

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen
问题如上，是因为设置的密码不符合mysql的密码验证规则所致。mysql

解决方法：sql

1.select @@validate_password_policy;    查看mysql密码验证级别（0/LOW/1/MEDIUM/2/STRONG）；ui

2.mysql> SHOW VARIABLES LIKE 'validate_password%';     查看具体的设置项；ci

3.validate_password_dictionary_file    用于验证密码强度的字典路径；rem

validate_password_length     密码的最少长度；io

validate_password_mixed_case_count     密码的字母大小写个数；require

validate_password_number_count    密码的数字个数；date

validate_password_policy    密码的级别；file

validate_password_special_char_count    密码的特殊字符个数；select

4.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%';  

重启mysql服务，再次执行GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

OK