今晚想在搭建好Mysql的Centos 服务器开启下远程访问。当我在执行:
mysql -u root -p #登录
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
提示:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements。这里就是说我的mysql密码强度太低,不允许我这样的操作。
解决:
mysql -u root -p #登录
mysql>set global validate_password_policy=0; #密码强度设为最低等级
mysql>set global validate_password_length=4; #密码允许最小长度为4
mysql>flush privileges; #更新授权表,生效