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

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

问题描述

我安装了 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:

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

  1. Go to file C:wampappsphpmyadmin3.2.0.1config.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

$cfg['Servers'][$i]['password']='NO'

  • 尝试再次打开 phpMyAdmin,希望消息现在显示用户 'root'@'localhost' 拒绝访问(使用密码:YES)

  • Try opening phpMyAdmin again, and hopefully the message will now read "Access denied for user 'root'@'localhost' (using password: YES)

    现在将上述行中的密码更改为yourpassword"(您之前设置的任何密码)

    Now change the password in the above line to 'yourpassword' (whatever you had set it to before)

    希望这对某人有所帮助.

    Hope this helps somebody.

    这篇关于MySQL 说:文档 #1045 - 用户 'root'@'localhost' 的访问被拒绝(使用密码:否)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

  • 本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

    相关文档推荐

    Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
    Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
    Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
    auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
    Sort by ID DESC(按ID代码排序)
    SQL/MySQL: split a quantity value into multiple rows by date(SQL/MySQL:按日期将数量值拆分为多行)