Question
Issues with setting password for MySQL root user during LAMP setup
- Posted May 8, 2022
- LAMP StackMySQL
Hello,
I am having issues setting up MySQL on a fresh droplet running Ubuntu 20.04.
I have been following the tutorial and have reached the sudo mysql_secure_installation step. I have tried setting the password for the root user with the VALIDATE PASSWORD PLUGIN enabled and without, but both return the following error: 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.
I have done this process multiple times on other projects using Ubuntu 20.04 and MySQL 8.0, but for some reason today it is not working.
Any ideas on where I am going wrong?
Cheers,
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @mikehermary,
You need to change the authentication parameters. To do so run this command in MySQL:
- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'mynewpassword';
Afterwards you should be able to run
- sudo mysql_secure_installation
