Lsphp72 not support caching_sha2_password when use MYSQL8.0.4


New Member

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

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!