The problem I'm facing is that I can only connect to the Google Cloud SQL instance if I leave the username and password fields blank in the SQuirrel SQL Client (root). Whenever I try logging in using the new user I created, I get an error stating "Unexpected Error occurred attempting to open an SQL connection."
Here is how I added the user, once connected to my Cloud SQL instance.
CREATE USER 'rob'@'%' IDENTIFIED BY 'mypass';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON testdb.* TO 'rob'@'%';
There is mention in the docs that I need to add the users as teammates to my project first (which I did), but I understand why this is really necessary. Does the MySQL user and the project team member username (email address) need to be the same? If so, this wouldn't make a lot of sense due to the 16 character username limitation for MySQL user names.
Any clarification would be appreciated.
Rob.
No comments:
Post a Comment