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?
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.