phpmyadmin连接多实例MySQL_通过phpMyAdmin管理mysql多实例

修改phpmyadmin根目录下的config.inc.php文件，例如这里我新增了一个localhost:3308

/* Servers configuration */

$i = 0;

/* Server: localhost [1] */

$i++;

$cfg['Servers'][$i]['verbose'] = '';

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['port'] = '3307';

$cfg['Servers'][$i]['socket'] = '/tmp/mysql3307.sock';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['user'] = '';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['hide_db'] = '';

$i++;

$cfg['Servers'][$i]['verbose'] = '';

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['port'] = '3308';

$cfg['Servers'][$i]['socket'] = '/tmp/mysql3308.sock';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['user'] = '';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['hide_db'] = '';

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';

$cfg['blowfish_secret'] = '';

$cfg['ServerDefault'] = 1;

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

$cfg['LoginCookieValidity'] = 18000; // >

?>