Add Multiple Hosts in phpMyAdmin

step 1 : install phpmyadmin (fedora user)
yum install phpmyadmin -y

step 2 : edit  file /etc/phpMyAdmin/config.inc.php
vim /etc/phpMyAdmin/config.inc.php
step 3 : Now add the following entries at the end of file.
 $i++;
 $cfg['Servers'][$i]['verbose'] = 'Database Server 2';
 $cfg['Servers'][$i]['host'] = '192.168.1.102';
 $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';
After adding the above entries in configuration file and access phpMyAdmin in web browser and you will get an option of server choice. Select server name to which you need to connect.


or you can use this to not enter username and password
$cfg['Servers'][$i]['user'] = 'YOURusername';
$cfg['Servers'][$i]['password'] = 'YOURPASSWORD';
-good luck-

Comments

Popular Posts