PHP with MySQL 8 0 error The server requested authentication method unknown to the client

Question

I'm running MySQL version 8 on PHP 7.0.

when I try to connect to my database from PHP I'm getting the following error:

Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

PHP show this error:

Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in D:\xampp\htdocs\reg\server.php on line 10

How can I fix this problem?

Answer 1

Edit my.cnf file and put this setting in mysqld section:

[mysqld]
default_authentication_plugin= mysql_native_password

Then run following command:

FLUSH PRIVILEGES;

I hope this helps you.