Connecting to GCP Cloud SQL MySQL

[tohabibe]

Hi,

Any tips on how to connecto to a GCP Cloud SQL instance of MySQL???

Keep getting a timeout error as in some type of authentication problem.

[Avinash]

@tohabibe
Hi,

The reason for your error may be because the connected party did not properly respond after a period of time. The possible reason for this can either be the database not being publicly accessible or requires whitelisting. Probable solution(s) can be:

• Enable whitelist toggle and add this ip in your DB Server rules.
• If not public - then connect via SSH Tunneling

You can refer the following documentation for common connector errors.

Common Connector Errors

EACCES | ER_DBACCESS_DENIED_ERROR| ER_ACCESS_DENIED_ERROR | ER_HOST_NOT_PRIVILEGED (Permission denied | Login failed Error) An attempt was made to get access in a way forbidden by its access permissions. Database prohibits granting access for given credentials. Probable Reasons Incorrect username or password Case mismatch for username or password The user does not exist You enter a password when no password is required for the specific database. User doesn’t have access to the given Database …

I hope this helps.