phpMyAdmin无法连接到MySQL服务器 [英] phpMyAdmin cannot connect to MySQL server

问题描述

我真的需要帮助解决此错误，因为请下周一是我的最后一年项目介绍.我不知道该如何解决.

我尝试遵循以下 http://www.ishaanrawat.com/solved-wampserver-1045-access-denied-for-user-rootlocalhost-using-password-no/指令，但出现相同的错误. /p>

几分钟前，我卸载了wamp服务器，希望再次安装后，我可以正常使用wamp服务器，但仍然会出现相同的错误.

以下是错误:

MySQL表示:文档

1045-用户'root'@'localhost'的访问被拒绝(使用密码:否)

phpMyAdmin尝试连接到MySQL服务器，服务器拒绝了该连接.您应该检查配置中的主机，用户名和密码，并确保它们与MySQL服务器管理员提供的信息相对应.

解决方案

您可以观看以解决您的问题
http://www.youtube.com/watch?v=BgcW4h6ZAro&t=7m21s
p/s:这是越南视频:)
在config.inc.php中，您可以编辑以下代码:

* First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//uncomment this
$cfg['Servers'][$i]['auth_type'] = 'cookie';
//comment this
//$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$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;

然后退出wampserver，重新打开wampserver，打开PHPMyadmin，您将显示登录表单:)

I really need help to fix this error, because next Monday is my final year project presentation, please. I don't know how to fix this.

I've try to follow this http://www.ishaanrawat.com/solved-wampserver-1045-access-denied-for-user-rootlocalhost-using-password-no/ instruction, but I get the same error.

And, a few minute ago, I uninstall wamp sever, in hope after installing it again, I can use my wamp server normally, but still the same error.

Below is the error:

MySQL said: Documentation

1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

解决方案

You can watch to solve your problem
http://www.youtube.com/watch?v=BgcW4h6ZAro&t=7m21s
p/s: this is Vietnamese video :)
in config.inc.php you edit folowing code:

* First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//uncomment this
$cfg['Servers'][$i]['auth_type'] = 'cookie';
//comment this
//$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$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;

then exit wampserver, reopen wampserver, open PHPMyadmin, you'll show login form :)

这篇关于phpMyAdmin无法连接到MySQL服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！