mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

Asked Dec 05 '21 at 04:57

Active Dec 05 '21 at 10:39

Viewed 28 times

I have edited my.ini File [mysqld] default_authentication_plugin= mysql_native_password, and also used the ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword;' command to solve the caching_sha2_password problem in MySQL,

but PHP still shows me these warnings:

Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

Warning: mysqli_connect(): (HY000/2054): The server requested authentication method unknown to the client

None of the solutions I've tried seems to be working. What should I do next?

edited Dec 05 '21 at 10:39

Dharman

30,962
25
85
135

asked Dec 05 '21 at 04:57

rb33l1

recheck you are changing the right user on the right server that corresponds to the PHP connection. – danblack Dec 05 '21 at 05:12
1

Should be fixed in PHP 7.4. can you upgrade? – ADyson Dec 05 '21 at 06:39

mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

0 Answers0