cloud-sql-proxy
cloud-sql-proxy copied to clipboard
GoogleCloudPlatform
Support `caching_sha2_password` authentication plugin with Proxy in Unix Socket mode
The Cloud SQL Proxy currently does not support the caching_sha2_password authentication plugin when listening over a unix socket.
This is an issue as in MySQL 8.4, caching_sha2_password has now become the default authentication plugin. Any new database users created with the caching_sha2_password will be unable to log in via the Proxy over unix socket.
Failed logins are not always clear that the authentication plugin is the root cause of the issue:
ERROR 1045 (28000): Access denied for user 'my-user'@'cloudsqlproxy~34.124.164.49' (using password: YES)
Some Cloud SQL Language Connectors are a viable alternative and workaround at the moment as they work with MySQL 8.4 and the caching_sha2_password plugin:
Unfortunately, the Java connector does not work with MySQL 8.4. We are actively working on a fix for the Java connector also.
