1. 在phpMyAdmin文件下,找到config.inc.sample.php,
将config.inc.sample.php改为 config.inc.php,打开
config.inc.php,
找到
Servers configuration,如下:
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] =
'localhost';
$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'] = false;
2. 在这之后添加你想要的服务器相关配置,如下:
/*
* Second server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] =
'192.168.1.201';
$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'] = false;
3.刷新页面,配置成功的话,如图:
开始学程序,用phpMyAdmin比较多。后来工作中,逐渐改用SQLyog,navicat比较多,用着就习惯了,个人感觉比phpMyAdmin要好用和灵活,工作效率高一些。