MicroHost

MicroHost

Did You Know?

How Can We Help?

Special Offer

Deploy your Cloud Server now and get $100 in Free Credits!

Get Started

How to Solve “The server requested authentication method unknown to the client” in phpMyAdmin

Table of Content

INTRODUCTION

In this tutorial, we will learn how to solve "The server requested authentication method unknown to the client" in phpMyAdmin.

requested authentication method unknown

The forementioned error is faced when connection for control user as defined in the configuration fails.

We use the following steps the resolve the error. requested authentication method unknown

Step 1. Run the following command

[console]mysql -u root -p[/console]

Step 2. Then run the below command to change the user’s authentication plugin type;

[console]ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';[/console]

Step 3. change the MySQL authenticate method in the mysql config file

[console]vi /etc/mysql/mysql.conf.d/mysqld.cnf[/console]

[console][mysqld][/console]

[console]default_authentication_plugin=mysql_native_password[/console]

requested authenticate method not known

Step 4. Then run the below command in the MySQL prompt.

[console]mysql -u root -p[/console]

[console]mysql > flush privileges;[/console]

Step 5. Now restart the MySQL service in the server.

[console]service mysql restart[/console]

Thank You!

Special Offer

Deploy your Cloud Server now and get $100 in Free Credits!

Get Started
Table of Contents