All geek questions in one place

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

When trying to connect to an instance of Google Cloud SQL through various MySQL clients, the root login now does not work with an error:

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

Earlier, I managed to log into the system and perform various tasks (create a local user, add tables and store procedures, etc.).

I can still log in as the local user that I created.

So, I have a:

  • Confirmed instance "IP address"
  • Authorized Networks Confirmed
  • Set and reset the "root password" several times
  • "Reset SSL Configuration"
  • Uncheck "Allow SSL connections only"
  • Restart an instance several times

Any suggestions for diagnosing a failed root directory entry?

Thanks for any help.

+4
source share
1 answer

This is a manifestation of error. Please follow the error status here .

As a workaround, try the following:

  • Add SSL to the instance (if it is not in place)
  • Connect using user = root with SSL
  • Delete user root @%
  • Uncheck (if enabled) "Allow SSL connections only"
  • Enter root password again
  • Now try connecting with user = root and the password set.
+7
source

Source: https://habr.com/ru/post/1535975/

More articles:


All Articles