When I ran
mysql_secure_installation I am getting the following message
... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.
How do I fix this and continue with
mysql_secure_installation? running on Ubuntu server?
- Open the terminal application.
- Terminate the
mysql_secure_installation from another terminal using the
sudo killall -9 mysql_secure_installation
- Start the mysql client:
- Run the following SQL query:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SetRootPasswordHere';
- Then run the following command to secure it:
- When promoted for the password enter the
SetRootPasswordHere (or whatever you set when you ran the above SQL query)
- That is all.