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

MySQL root can’t login to phpMyAdmin
phpmyadmin

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *