phpmyadmin连接多个MySQL数据库

来源：互联网发布：颜值高的手机知乎编辑：程序博客网时间：2024/06/05 16:32

在phpmyadmin的根目录下建立config.inc.php

写入如下代码：

<?php
//phpmyadmin 配置文件

//本地MySQL数据库
$i=1;
$cfg['Servers'][$i]['host']          = 'localhost';
$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'root';
$cfg['Servers'][$i]['port']          = '';

$i++;
$cfg['Servers'][$i]['host']          = '192.168.16.16';
$cfg['Servers'][$i]['user']          = '*******';
$cfg['Servers'][$i]['password']      = '*******';
$cfg['Servers'][$i]['port']          = '';

$i++;
$cfg['Servers'][$i]['host']          ='192.168.16.30';
$cfg['Servers'][$i]['user']          = '*******';
$cfg['Servers'][$i]['password']      = *******';
$cfg['Servers'][$i]['port']          = '';

$i++;
$cfg['Servers'][$i]['host']          ='192.168.18.188';
$cfg['Servers'][$i]['user']          = '*******';
$cfg['Servers'][$i]['password']      = '*******';
$cfg['Servers'][$i]['port']          = '';

配置完毕之后，重新打开phpmyadmin，在右上角的服务器下拉框下面就会多出3个选项,就是你想要的喽