Multiple servers on PHPMyAdmin

By DevOps Developer

Hello guys,

if you want to use a production database on your local PHPMyAdmin then simply put below code with live credential on your PHPMyAdmin/config.inc.php

it’s also used for using another server on your local machine like Workbench, Sequal Pro, etc.

$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;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';

Thanks For Reading…