Webmaster2020.com

Posted: **Fri Mar 20, 2020 9:15 pm**

Hi,

I get the following error whe I tried to connect with php to MySQL server.
mysqli::__construct(): The server requested authentication method unknown to the client

How can I fix this?
I use standard login function:
$dbconn=new mysqli('127.0.0.1','user','passwd','database');

Posted: **Fri Mar 20, 2020 9:23 pm**

MYSQL has changed it type of password (since Mysql 8 ?)
Anyway the easiest solution, is execute the following SQL command on MYSQL

Code: Select all

ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';

It should solve your problem.

Webmaster2020.com

php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

Re: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]