linux mysql5.7 密码相关问题

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

 select @@validate_password_length;

mac mysql error You must reset your password using ALTER USER statement before executing this statement.

SET PASSWORD = PASSWORD(‘your new password‘);

flush privileges;

 

新增用户并授权

 

use mysql; Grant all on *.* to 'root'@'%' identified by 'root用户的密码' with grant option;

flush privileges;