Entries by Erik Svensson

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 […]