安装phpMyAdmin

phpmyadmin官网
我下载的是phpMyAdmin-4.8+snapshot-all-languages.zip

配置Apache的httpd.conf

<Directory "你的phpMyAdmin的文件夹位置">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Allow from all
</Directory>

在根目录下复制config.sample.inc.php 另存为config.inc.php，并修改其部分内容

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['user'] = 'root'; //mysql username
$cfg['Servers'][$i]['password'] = 'xxxx'; //mysql password
$cfg['Servers'][$i]['auth_type'] = 'config'; // 这里如果设置为cookie 则需要登录进入phpmyadmin

/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false; // 这里修改是否允许空密码登录