详细说明phpmyadmin连接，管理多个mysql服务器

1，将phpMyAdmin根目录下的config.sample.inc.php，重命名为config.inc.php

2，修改config.inc.php文件

/* * First server */ //如果要管理，更多个mysql服务器，就修改$connect_hosts这个数组就行了 $connect_hosts = array(            '1'=>array(                 "host"   => "localhost",  //服务器1                 "user"   => "root",                 "password" => ""                 ),            '2' => array(                 "host"   => "192.168.0.11", //服务器2                 "user"   => "wordpress",                 "password" => "*******"                 )            );for ($i=1;$i<=count($connect_hosts);$i++) { /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = $connect_hosts[$i]['host'];   //修改host $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['AllowNoPassword'] = true; $cfg['Servers'][$i]['user'] = $connect_hosts[$i]['user'];  //修改用户名 $cfg['Servers'][$i]['password'] = $connect_hosts[$i]['password']; //密码 /* rajk - for blobstreaming */ $cfg['Servers'][$i]['bs_garbage_threshold'] = 50; $cfg['Servers'][$i]['bs_repository_threshold'] = '32M'; $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600; $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';}

注意一点，数组下标不要从0开始，不然会提示错误的，无效的服务器索引：“0”

登录前，

phpmyadmin 修改config.inc.php 多服务器登录

登录后，

phpmyadmin 连接多个mysql服务器，登录后

有一点要注意，用localhost登录后，选择上图下拉中的192.168.0.11后，还会让你登录，都登录后，在多个服务器这间切换就不要在登录了。

原文：http://blog.51yip.com/mysql/1250.html