Saturday, December 9, 2017

[google-cloud-sql-discuss] phpmyadmin connecting to cloud sql


Hello. I am attempting to connect phpmyadmin to cloud sql. This should be pretty simple but can't seem to make it work. I am connecting from a GCE instance. 
I have added the GCE IP address to the authorization section of my Google SQL server. Below is my config.inc settings. It simply does not connect. Errors with connection refused. What am I missing here? 
Been staring at this for too long and not sure what is missing. 

Do I need MYsql client installed and running on GCE to use phpmyadmin to connect to Google SQL? 

$cfg['Servers'][$i]['host']          = '<SERVER IP>';  $cfg['Servers'][$i]['port']          = '3306';  $cfg['Servers'][$i]['socket']        = '';  $cfg['Servers'][$i]['connect_type']  = 'tcp';  $cfg['Servers'][$i]['extension']     = 'mysql';  $cfg['Servers'][$i]['user']          = 'root';  $cfg['Servers'][$i]['password']      = 'password';  $cfg['Servers'][$i]['auth_type'] = 'config';       // keep it as config  $cfg['Servers'][$i]['AllowRoot']     = TRUE;  $cfg['Servers'][$i]['AllowNoPassword']   = TRUE;

--
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/188f5d72-83a7-4648-bf1d-d0202615b5bd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment