知乎專欄 | 多維度架構 |
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';