mysql - phpMyAdmin 不允许访问

Question

我正在使用 WAMP/phpMyAdmin 但无法访问它 :(它需要密码并提供 root 用户名和 blacnk 密码拒绝访问!!!

Answer 1

看看http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

创建一个新帐户然后从 phpMyAdmin 目录打开 config.inc.php 并进行这些更改

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$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'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>