Hello,
When I try to connect my database,I get a error log:
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
Because I use MYSQL8.0, it have [caching_sha2_password] as its the default_authentication_plugin,
please see it https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-4.html#mysqld-8-0-4-security
For the server, the default value of the default_authentication_plugin system variable changes from mysql_native_password to caching_sha2_password.
The libmysqlclient library treats caching_sha2_password as the default authentication plugin rather than mysql_native_password.
I test lsphp72_mysqlnd, it can not support [caching_sha2_password]
please help me,thanks!
Coxxs
When I try to connect my database,I get a error log:
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
Because I use MYSQL8.0, it have [caching_sha2_password] as its the default_authentication_plugin,
please see it https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-4.html#mysqld-8-0-4-security
For the server, the default value of the default_authentication_plugin system variable changes from mysql_native_password to caching_sha2_password.
The libmysqlclient library treats caching_sha2_password as the default authentication plugin rather than mysql_native_password.
I test lsphp72_mysqlnd, it can not support [caching_sha2_password]
please help me,thanks!
Coxxs