MySQL 5.7 and mysql_secure_installation
If you are using mysql:secure_installation witch you should, beware of that the script reset all passwords in the SQL server database mysql. To fix this problem use the following.
Root password:
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass’;
Session password:
ALTER USER ‘mysql.session’@’localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
Exampel error messages:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
Leave a Reply
Want to join the discussion?Feel free to contribute!