[google-cloud-sql-discuss] Re: Why do I get "Access denied for user 'root'@'%' (using password: YES)" when I sign on from Sequel Pro and add or change a user?

Please confirm how are you accessing DB from Sequel Pro? Are you accessing via authorized IP address? 

If you connect to your instance using IP addresses, you must add your client IP address as an authorized address, even if your user's host name is unrestricted (root'@'%)[1].  

If above does not resolve the issue, I will suggest raising this issue on Google public issue tracker platform[2] with logs and error screenshots as PIT meant for bugs, customer issues, and feature request tracking. Google group platform is meant for general product-related discussion. 

[1]: https://cloud.google.com/sql/docs/mysql/users?hl=en_US&_ga=2.7722098.-1716057039.1509374682

[2]: https://issuetracker.google.com

On Monday, March 12, 2018 at 5:26:31 PM UTC-4, James Lampert wrote:

I have a Google Cloud SQL MySQL (Second Generation) instance. And I've granted myself %-level remote access to it.

Accessing it from Sequel Pro (https://www.sequelpro.com), as ROOT, I find that if I create a user from the Sequel Pro "Users" panel, it gets created, with the specified password, but I get an "Access denied for user 'root'@'%' (using password: YES)" message, and it won't accept granting that user remote access unless I disconnect and reconnect my ROOT Sequel Pro session.

Once I disconnect and reconnect as ROOT, I can successfully give the user remote access, but it gives me the "Access denied for user 'root'@'%' (using password: YES)" message. And I can successfully grant it privileges, but again, it gives me the "Access denied for user 'root'@'%' (using password: YES)" message.

Can anybody here shed any light on this?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9bfb00d2-3d7f-4d0d-8ebc-e356ddfce4e8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.