MySQL 说:文档 #1045 - 用户 'root'@'localhost' 访问被拒绝(使用密码:NO)-数据库问题

MySQL said: Documentation #1045 - Access denied for user #39;root#39;@#39;localhost#39; (using password: NO)(MySQL 说:文档 #1045 - 用户 root@localhost 访问被拒绝(使用密码:NO))

本文介绍了MySQL 说:文档 #1045 - 用户 'root'@'localhost' 访问被拒绝(使用密码:NO)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我安装了 xampp，但是当我尝试运行它时出现错误:

I installed xampp,but when I tried to run it I got an error as thus:

错误

MySQL 说:文档

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

Connection for controluser as defined in your configuration failed. 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.

我尝试在互联网上搜索解决方案，但仍然无法解决我的问题.我已经在config.inc.php文件中检查过我是否使用了密码，但我没有使用任何密码.另外，当我尝试使用密码访问时，我仍然无法解决这个问题.

I tried to search on internet for a solution, but I still can't fix my problem. I have already checked whether I used a password or not in config.inc.php file but i have not used any password.Also, when i try to access with a password, I still can't solve this problem.

我希望有人能帮助我..谢谢

I hope anyone can help me. .thank you

推荐答案

我在 phpMyAdmin 中更改了 root 用户的密码后遇到了这个问题.我对编程一无所知，但我通过执行以下操作解决了它:

I had this problem after changing the password for the root user in phpMyAdmin. I know nothing about programming but I solved it by doing the following:

转到文件 C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php(如果你没有使用 Wamp 服务器)

Go to file C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php (I guess you would replace "wamp" with the name of your server if you're not using Wamp Server)

找到行 $cfg['Servers'][$i]['password']='' 并将其更改为

Find the line $cfg['Servers'][$i]['password']='' and change this to