Xampp可以连接服务器上mysql,但是需要修改一些环境。
路径:D:\Xampp\phpMyAdmin
修改文件:config.inc.php
添加数据: Second server(在后面添加即可)
/*
* Second server
*/
$i++;
$cfg['Servers'][$i]['verbose'] = '服务器命名';
$cfg['Servers'][$i]['host'] = 'IP';
$cfg['Servers'][$i]['port'] = '端口号';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '账号';
$cfg['Servers'][$i]['password'] = '密码';
最终效果: