You are here
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?
Hi Gary
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...
Wrong directory
Looks like the confiruration file is not where I expected it to be. Once I found the correct directory everything started to work.
It was recommended to me to
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?
Sorry for delayed response
Add new comment