Can not connect to mysql remote server using phpmyadmin

Question

I install a phpmyadmin application in a cloud9 workspace. The I configure it to connect a mysql server running in another cloud9 workspace. To configure it I just add the following lines on the phpmyadmin configuration file (/var/lib/phpmyadmin/config.inc.php):

i++;
$cfg['Servers'][$i]['host'] = '[my IP]:3306'; 
$cfg['Servers'][$i]['user'] = 'madeiraod';
$cfg['Servers'][$i]['password'] = '[my password]';
$cfg['Servers'][$i]['auth_type'] = 'config';

I just follow the instructions in here

When I open phpmyadmin I can not access the remote server and I get always in the top of the application the string that I added to the configuration file:

i++; $cfg['Servers'][$i]['host'] = '[my IP]:3306'; $cfg['Servers'][$i]['user'] = 'madeiraod'; $cfg['Servers'][$i]['password'] = '[my password]'; $cfg['Servers'][$i]['auth_type'] = 'config';

Why the configuration appears in the beginning of the phpMyAdmin instead of being processed?

Possible duplicate of SQLSTATE[HY000] [2002] A connection attempt failed.. - When attempting to connect from Local to remote server — e4c5

miguelbgouveia miguelbgouveia · Accepted Answer · 2016-10-27T16:02:33

I found the problem. It was missing the php tags:

<%p 
  i++;
  $cfg['Servers'][$i]['host'] = '[my IP]:3306'; 
  $cfg['Servers'][$i]['user'] = 'madeiraod';
  $cfg['Servers'][$i]['password'] = '[my password]';
  $cfg['Servers'][$i]['auth_type'] = 'config';
%>

Can not connect to mysql remote server using phpmyadmin

1 Answers