[Solved] Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method

I was trying to setup MySQL server on Ubuntu after package installation but faced following error during mysql_secure_installation,so I followed the below method to fix it.

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.

Solution:

Open another terminal and login to mysql: sudo mysql
then execute the following command to set a password.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'PASSWORD_HERE';


Also read: Install WordPress (LAMP) On CentOS 8

Leave a Reply