MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
来源:互联网 发布:linux mount rw 编辑:程序博客网 时间:2024/06/06 00:19
解决方案:
- 打开MySQL目录下的my.ini文件,在文件的最后添加一行“skip-grant-tables”,保存并关闭文件。(WIN7默认安装,my.ini在C:\ProgramData\MySQL\MySQL Server 5.6)
- 重启MySQL服务。
- 通过命令行进入MySQL的BIN目录,输入“mysql -u root -p”(不输入密码),回车即可进入数据库。(WIN7默认安装,BIN目录为:C:\Program Files\MySQL\MySQL Server 5.6\bin)
- 执行“use mysql;”,使用mysql数据库。
- 执行“update user set password=PASSWORD("123456") where user='root';”(修改root的密码)
- 打开MySQL目录下的my.ini文件,删除最后一行的“skip-grant-tables”,保存并关闭文件。
- 重启MySQL服务。
- 在命令行中输入“mysql -u root -p 123456”,即可成功连接数据库。
完成以上步骤,MyEclipse也可成功连接MySQL了。
0 0
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MySql 出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).问题解决方案
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)(亲测解决)
- MYSQL问题解决方案: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) 问题解决
- 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)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- 利用 Python 进行数据分析(十二)pandas:数据合并
- instanceof、isInstance、isAssignableFrom的用法介绍
- 再遇PAT天坑之1075. PAT Judge (25)
- 洛谷日记2
- 指定控件的边框线
- MYSQL问题解决方案:Access denied for user 'root'@'localhost' (using password:YES)
- 修改vim配色
- 2017.4.15南海中学创新班
- Android MVP 架构二 Presenter与Model
- 人民币汇率市场化历程
- 2017第八届蓝桥杯B组省赛第六题:最大公共子串
- 自增两种方式区别
- 二叉树的最大节点
- HDFS学习总结