search

yoichiro / chrome_mysql_admin

ChromeMyAdmin provides you the administration GUI of MySQL server. It is like phpMyAdmin, Sequel Pro.
https://www.eisbahn.jp/chrome_mysql_admin
Apache License 2.0
140 stars 33 forks source link

How to connect to Google Cloud SQL? #22

Open sajandnair opened 9 years ago

sajandnair commented 9 years ago

Hello,

I am new into Google Cloud SQL and using Google Chromebook to connect to it.

I hope Chrome mySQL Admin very useful, since the Google provided tool is very primitive.

I tried to use the same connection details which i used in SquirrelSQL, but could not connect.

Could not find useful information from google (https://cloud.google.com/sql/docs/mysql-client#connect-no-ssl)

Please help, if possible.

Thanks.

yoichiro commented 9 years ago

@sajandnair I have an experience to connect to the Cloud SQL server from Chrome MySQL Admin with SSL. This point is that the "Check CN" is OFF, because the domain which the certificate has is not same as the host domain you want to connect to.

sajandnair commented 9 years ago

Thanks for your quick reply.

Please note that we are trying to connect without SSL. The Cloud SQL control panel allows you to connect without SSL.

phillymontana commented 9 years ago

I am having the same problem. I am able to connect to the Google Cloud SQL DB instance using a cloud based tool, but not with this chrome app (chrome mysql admin). Does the chrome mysql admin app use a different IP address to connect from? Google Cloud SQL settings need to know where the sql client is connecting from. I simply found my external IP address and used that one. Maybe I am wrong?

please help me understand how to get this tool to work. thank you.

znorris commented 8 years ago

@phillymontana Add your external IP address to the Cloud SQL access control list so for instance 8.8.8.8/32. Obviously that's not the correct IP but the CIDR notation is correct for a single IP. I'm able to connect non-SSL to Cloud SQL this way.

csaleman commented 7 years ago

@yoichiro I'm having issues connecting to Google Cloud SQL with SSL enabled and MySQL Admin version 4.6.4. I have configured the Access and SSL credentials and I'm able to connect from the same IP with MySQL Workbench. Also Check CN = NO This is the error I'm getting:

Connection failed.

Access denied for user 'root'@'<1.2.3.4>' (using password: YES)

-- Thank you.