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.

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, it not support [caching_sha2_password]

please help me,thanks!


Yes, mysql 8.0 use new auth , I also tested several others environment with php72 and php73 , none of them supports this new auth ,for now you can set mysql to use native_password.

meanwhile we will also seek into the possibility to make this works.