Access denied for user 'root'@'localhost' (using password:YES)解决方法
来源:互联网 发布:衣服数据参考 编辑:程序博客网 时间:2024/04/30 04:34
在MySQL的使用过程中,我们可能会碰到“Access denied for user 'root'@'localhost' (using password:YES)”的问题,那么接下来我们就来解决它。
经过我的百度查询最后得出结论:出现这种错误有两种可能,一是MySQL的root用户的密码错误,二是权限不够的问题。通常解决办法是修改密码。。。
由于我使用的是Windows系统,所以方法也是Windows系统的修改方法:
1、开始 → 搜索栏里面输入cmd → 右键cmd.exe选择以管理员的身份运行(亦可以在C:\Windows\System32目录下找到这个cmd.exe,右键,以管理员身份运行)
2、输入net stop mysql停止MySQL服务
3、输入命令行来到mysql的bin目录下,输入下列粗体命令
D:\MySQL\bin>mysqld --defaults-file="D:\MySQL\my.ini" --console --skip-grant-tables
等一下,显示出以下结果说明MySQL启动:
170215 22:26:09 [Warning] The syntax '--log' is deprecated and will be removed inMySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
170215 22:26:09 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
170215 22:26:09 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
170215 22:26:09 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
170215 22:26:09 [ERROR] The update log is no longer supported by MySQL in version 5.0 and above. It is replaced by the binary log. Now starting MySQL with --log-bin='' instead.
170215 22:26:09 InnoDB: Started; log sequence number 0 324221
170215 22:26:09 [Note] mysqld: ready for connections.Version: '5.1.33-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
4、再以管理员的身份打开一个cmd.exe,输入命令行来到mysql的bin目录下,输入:mysql -uroot mysql
5、执行,“use mysql;”使用mysql数据库。
6、进入mysql之后,输入命令行修改密码:
mysql>update user set password=PASSWORD("root") where user='root';”
7、刷新权限:mysql>flush privileges;
8、退出mysql:mysql> quit;
9、至此修改密码完成,可以输入命令行:net start mysql 启动MySQL服务,mysql -uroot -p ,输入密码就可以进入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)解决方法
- 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)
- java开发遇到的简单问题
- 二叉树的顺序存储实现及遍历
- 【uva-124】Following Orders (拓扑排序)竟然自己写出了全排列的算法!
- 18届清华硕士收割18家互联网sp offer总结
- Python---思维导图
- Access denied for user 'root'@'localhost' (using password:YES)解决方法
- 《编程之美》介绍和pdf下载
- hdu1272小希的迷宫(并查集)
- golang web开发框架httprouter:开发简单的 REST API 服务器
- spring入门程序HelloWorld
- 集合类,Collection,List
- 【uva-10305】Ordering Tasks (拓扑排序中最简单的一道
- 完美解决Android Studio在gradle上的各种问题
- Ubuntu 17.04 安装Hadoop 3.0.0-beta1