phpMyAdmin can't connect to remote sever on Windows 7 from Linux client

Question

I cannot connect to mysql server on Windows 7 from my phpMyAdmin on Linux machine.

I've configured phpMyAdmin by modifying common.inc.php. I've added at the bottom of common.inc.php the following lines:

$i=2;
$cfg['Servers'][$i]['host'] = 'HostName:port'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'userName';      //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Password';  //password
$cfg['Servers'][$i]['auth_type'] = 'config';   // keep it as config
$i++;

I see a drop down menu with remote server listed, but when I selected a remote server phphMyAdmin returns to localhost and it doesn't connect to remote without error messages.

Using mysql command to connect to the remote database server and using the same user/password, I can successfully connect to the database server.

The versions are:

PHP 5.4.16 Development Server
phpMyAdmin 4.4.15.10
MySQL 5.6.32 - MySQL Community Server (GPL)

The request is initiated from the post Error from phmpMyAdmin when is configured in order to access remote server with local phpMyAdmin client where I have entered a request regarding the configuration of phpMyAdmin

score 0 · Answer 1 · answered Jul 06 '17 at 10:46

0

Using the port number in the 'host' directive is not supported. Use the '$cfg['Servers'][$i]['port']' directive to indicate the port number. https://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_port

answered Jul 06 '17 at 10:46

Marc Delisle

8,879
3
29
29

I'm not using port number, the setting posted is only an example. – famedoro Jul 06 '17 at 11:41

famedoro · Answer 2 · 2017-07-06T11:01:34.690

0

I've resolved in this way: put the setting lines after $GLOBALS['server'] = 0; with the variable i initialized to 1 ( $i=1; ) instead of put them at the bottom of common.inc.php.

edited Jul 06 '17 at 11:01

answered Jul 06 '17 at 10:52

famedoro

1,223
2
17
41

Did you use a port number? – Marc Delisle Jul 06 '17 at 11:28
@Marc Delisle I'm not using port number, the setting posted is only an example – famedoro Jul 06 '17 at 11:42

score 0 · Answer 3 · answered Jul 06 '17 at 12:14

You can access the remote server by adding a block of code in your phpmyadmin config file...

$i++;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

try this

phpMyAdmin can't connect to remote sever on Windows 7 from Linux client

3 Answers3

Linked