Forum archive
Connecting to remote mysql server
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?
Looks like the confiruration file is not where I expected it to be. Once I found the correct directory everything started to work.