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?

[James Lampert]

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?

[Dinesh (Google Platform Support)]

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 discussions. 

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

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