Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎专栏 | Search | About

13.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

MySQL 5.7 密码强度,必须含有0-9,a-z,A-Z以及“-”或“_”

https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html

禁用密码安全策略(早起5.7版本可用,新版已经废弃这个选项)

#  cat /etc/my.cnf | grep validate-password
validate-password=OFF
		

新的方式修改策略与密码长度

		
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=4;
mysql> grant all privileges on test.* to 'test'@localhost  identified by 'chen';