I have setup a Cloud SQL instance, wich is running mysql 8.0.44, with the flag default_authentication_plugin set to mysql_native_password. Unencrypted network traffic is allowed (due to legacy issues).
With root I have updated a user:
alter user ‘username’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
flush privileges;
User shows up in mysql.user with plugin mysql_native_password.
But when trying to connect with legacy software (php 5.6.x) I still get the following error:
mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
We have a live database running on mysql 8.0.18 (without the additional flag and user settings), with the same legacy software connections are accepted without any problems.
Any ideas would be welcome! 