首页 > 代码库 > mac mysql error You must reset your password using ALTER USER statement before executing this statement.

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

安装完mysql 之后,登陆以后,不管运行任何命令,总是提示这个

step 1: SET PASSWORD = PASSWORD(‘your new password‘);

step 2: ALTER USER ‘root‘@‘localhost‘ PASSWORD EXPIRE NEVER;

step 3: flush privileges;

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