How can I diagnose root login failure to Google Cloud SQL?

Question

When attempting to connect to a Google Cloud SQL instance via various MySQL clients, the root login is now failing with the error:

$ mysql --host=173.194.x.x --user=root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'98.225.x.x' (using password: YES)

I was previously able to login and perform various tasks (create a local user, add tables and store procedures, etc.).

I can still login as the local user I created.

So, I have:

• Confirmed the instance "IP Address"
• Confirmed the "Authorized Networks"
• Set and reset the "Root Password" multiple times
• "Reset SSL Configuration"
• Cleared the checkbox for "Only allow SSL connections"
• "Restarted" the instance multiple times

Any suggestions on diagnosing root login failure?

Thanks for any help.

Answer 1

It is a manifestation of a bug. Please follow the status of the bug here.

As a workaround please try the following steps:

1. Add SSL to the instance (if one is not in place)
2. Connect using user = root with the SSL
3. Remove the user root@%
4. Uncheck (if checked) the "Only allow SSL connections"
5. Set the root password again
6. Now try and connect with user = root and the password that was set.