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

Comments

Leave a Reply

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