DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’» is a community of 967,911 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
Kelvin Murumba
Kelvin Murumba

Posted on

Fix PHPMyAdmin Error: requested authentication method unknown to the client [caching_sha2_password]

While installing PHPMyAdmin on your Mac OS, you might encounter the following error:

Alt Text

mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
Enter fullscreen mode Exit fullscreen mode

This error happens because of the change in authentication in the later MySQL versions.

This is how to solve the above error:

  1. Make sure your MySQL Server is running

Alt Text

  1. From your terminal, login to MySQL:

sudo /usr/local/mysql/bin/mysql -u root -p

Enter the password you used to setup MySQL

  1. Run the below command from MySQL shell:

ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

OR

ALTER USER root IDENTIFIED WITH mysql_native_password BY 'password';

Replace user and password with your actual values.

Top comments (1)

Collapse
 
hassan_athmani profile image
Hassan Athmani

Hello Kelvin,
Thank you for the fix, I found out that the user needs to run the command flush privileges; after performing the ALTER operation, or just restarting the MySQL server.

🌚 Life is too short to browse without dark mode