wamp mysql 远程连接数据库,wampserver中的phpmyadmin 连接远程MySQL数据库配置

1、打开wampserver下phpmyadmin的目录在D:\wamp\apps\下      D:\wamp\apps\phpmyadmin4.1.14

2、找到config.inc.php文件，打开修改要连接的远程MySQL的host，user和password，更改这3个信息即可

其中必须保证数据库有被远程连接的权限

/* Authentication type */

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

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

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

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

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

/* Server parameters */

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

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

$cfg['Servers'][$i]['compress'] = false;

/* Select mysql if your server does not have mysqli */

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

$cfg['Servers'][$i]['AllowNoPassword'] = true;