phpMyAdmin allow connecting to multiple servers
phpMyAdmin configuration file is config.inc.php located in phpMyAdmin install folder.
To enable connecting to arbitary Server, add
$cfg['AllowArbitraryServer'] = true;
This will allow you to enter server IP or hostname to connect to.
To add connecting to differnt predefined servers, you can add following to end of config.inc.php
$i++; $cfg['Servers'][$i]['host'] = 'database-1.abxfzy3gt.us-east-2.rds.amazonaws.com'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'yoursecretpassword'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['auth_type'] = 'config';
Repeat this for any number of MySQL servers you need to connect.
Related Posts