error:105 Access denied for user 'root'@'localhost' (using password:YES)
来源:互联网 发布:步步高v205软件java 编辑:程序博客网 时间:2024/06/05 23:57
使用mysql数据库的时候,有时会遇到这个问题,而网上有些解决办法既复杂,而且基本都是ctrl+c,ctrl+v,所以今天为大家提供一下我的解决方法
一:在mysql安装目录下找到my.ini文件
ctrl+f 查找Mysqld,在[Mysqld]后面加上skip-grant-tables,保存关闭
二:打开cmd,直接输入 mysql -u root -p回车,这时如果要求密码,直接回车(如果报错,可能是配置文件修改没有生效,请重新启动电脑,重复此步骤)
三:打开cmd,输入mysql -u root -p后,直接输入update user set password=PASSWORD("你的密码") where user='root'回车(如果报错类似grant什么什么的,就删除第一部中my.ini中的[Mysqld]后面加的skip-grant-tables,重启电脑,重复此步骤),现在新密码就设置好了,第三步是为了设置密码,如果你不用密码,这步可以不做、
那么恭喜,你的问题圆满解决了
0 0
- error: 'Access denied for user 'root'@'localhost' (using password: YES)'
- error:105 Access denied for user 'root'@'localhost' (using password:YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES) 问题解决
- 解决'Access denied for user 'root'@'localhost' (using password: YES)'
- access denied for user 'root'@'localhost' using password yes
- access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- Access denied for user 'root'@'localhost' (using password: YES)解决办法
- Access denied for user: 'root@localhost' (Using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES) 解决方案
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- hibernate.cfg.xml中信息详解
- 定义a:link、a:visited、a:hover、a:active
- 【Sql Server学习】Sql Server基础第一篇
- 【Linux】solaris 10系统常用命令收集
- poj 2785 4 values whose sum is 0
- error:105 Access denied for user 'root'@'localhost' (using password:YES)
- C++内存检测工具
- 10 BroadcastReceiver
- 如何用VB编写自己的DLL文件,并调用其中的函数
- CodeForces 448B
- Servlet的基本架构
- android用户界面之WebView教程实例汇总
- c++Primer,三,标准库类型
- Log4j 中使用数据库连接池