Google cloud sql iam auth login isn't working with datagrip and google cloud code plugin

[its-raj21]

HI Team,

IDE: Datagrip
DB: mysql 8

I'm able to connect to google cloud sql using cloud iam auth with cloud proxy using the following command.

cloud-sql-proxy -i --private-ip

Then in datagrid datasource, just user username without password.

But I really didn't find any option to enable Automatic IAM Authentication with cloud code plugin.

When I tried to use my IAM id, I always get the following error.
SSL connection required for plugin "mysql_clear_password". Check if 'sslMode' is enabled.

I tried all possible solution from internet, I didn't help. As per my understanding automatic iam authentication isn't enabled with cloud code.

Please assist.

Regards,
Raj

[ivanporty]

Thanks for the report @its-raj21! We do have an option to connect using Private IP

Does it help or you are always required to enter password when using Cloud Code connection?

[its-raj21]

private ip is not the problem, we are able to connect using cloud sql proxy (Private IP) For IAM auth, with password or without password, we get the following error. SSL connection required for plugin "mysql_clear_password". Check if 'sslMode' is enabled.

steps to reproduce the the issue.

Create a user for sql instance with IAM auth (cloud identity) and try to login with that user. I believe Automatic IAM Authentication option is missing with cloud code.

Cli have the following flag. -i, --auto-iam-authn (*) Enables Automatic IAM Authentication for all instances

[ivanporty]

Thanks @its-raj21! We will look into adding support for IAM auth in Cloud Code and let you know.