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

Hello Allen,

In order to isolate the cause of issue, I'd recommend trying to connect to your Cloud SQL instance using mysql client by following the instructions described in this article. After a successful connection, you can then inspect the configuration of phpMyAdmin's client. For further information on phpMyAdmin's configurable data, you can refer to this doc. Please note that it is recommended to use mysqli as value for $cfg['Servers'][$i]['extension'] .

I hope this helps.

  


On Saturday, December 9, 2017 at 12:10:24 PM UTC-5, Allen Saslaw wrote:

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/2cd48b28-26c2-48b8-b60d-f339bdb9b48e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.