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

phpMyAdmin Installation and configuration on ubuntu 22.04 error solved using following steps.

Then run this ALTER Query to change the authentication parameters.

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

Now you will be able to change the password and login with new password.

#mysql_secure_installation

The above shell script available on Unix systems, and enables you to secure the MySQL installation by enabling you to set a password for root accounts.

Now user has to login on change the authentication parameters to do so just run this command first.

sudo mysql

Related Post

Leave a Reply

Your email address will not be published.