Once phpMyAdmin is
installed by default it is configured to access the local database. If we want to
access the remote database we have to edit the phpMyAdmin configuration. In linux environment configuration file is
mostly available in /etc/phpMyAdmin/config.inc.php
To connect the remote
database we have to change the host name in the configuration file.
$cfg['Servers'][$i]['host'] = <<Server
Name>>
To configure multiple database server
Add the following
entries at the end of the file.
$i++;
$cfg['Servers'][$i]['verbose'] = <<Name
which you want appear in the drop down>>
$cfg['Servers'][$i]['host'] = <<Database server name or Ip Address>>
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] =
false;
Once you have added
this line, Now we can see a Server
dropdown in the phpMyAdmin login page.
Select the server name and appropriate password to login.
