Gary Samuels's picture

I have installed on my local machine MsSQLWorkbench. With a URL, usrsername and password I can connect to a remote mysql server. 

I have installed phpmyadmin on a Amazon Machine Instance. I can open phpmyadmin but I can't connect to the same remote server as above. On the AMI I have /usr/share/phpmyadmin/config.sample.inc.php. I made a copy and named it config.inc.php. In this file I placed this information:

 

/*
 * Servers configuration
 */
$i = 0;


/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/*
 * Second server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'signon';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'my server.amazonaws.com:3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['user'] = 'my username';
$cfg['Servers'][$i]['password'] ='my password';

 

Can anyone tell me why this is not woking?

Forum: 
Tags: 
Jeremy Davis's picture

Welcome to the TurnKey Linux forums. It doesn't sound like you are using TurnKey so I can only guess...

First thing I would check is if it is listening for remote connections. By default all our appliances that include MySQL have it bound to localhost. Also Amazon block ports by default too. FWIW our MySQL appliance is already pre-configured to allow remote MySQL connections and if launched via the Hub it has Amazon security profile pre-configured to allow connections on the default MySQL port...

Gary Samuels's picture

Looks like the confiruration file is not where I expected it to be. Once I found the correct directory everything started to work.

Gary Samuels's picture

It was recommended to me to run PHPMyAdmin on a different server (not my AWS RDB MySQL server ) so I initiated a new AMI and then loaded Turnkey PHP FastCGI Server on it because I read it was preloaded with PHPMyAdmin. I can login to the Turnkey server and I have 3 options; Webshell, Webmin & PHPMyAdmin. When I open PHPMyAdmin I only see the database's on the Turnkey server.

The Turnkey Server is configured with the Nginx Security Group. I just noticed that the Turnkey server is located in the us-west-2b zone while the database server is in the us-west-2c zone, would this make a difference?

 

Jeremy Davis's picture

But glad to hear that you got it sorted...

Add new comment