Add new servers to phpMyAdmin

Categories: MySQL, Databases

Add this into the config.inc.php file after adding the remote user and securing the connection:

$i++;
$cfg['Servers'][$i]['verbose'] = 'Server Name';
$cfg['Servers'][$i]['host'] = 'Host Name';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = TRUE;

References: https://medium.com/@tiwarishani/multiple-servers-on-phpmyadmin-8995c9f95ba1

«
»