Mysql(Windows)--- Access denied for user 'root'@'localhost'(using password:YES)
来源:互联网 发布:软件怎么彻底删除 编辑:程序博客网 时间:2024/06/05 08:03
在windows下安装并启动Mysql后,用客户端工具Navicat for MySQL进行连接,报错:
此错误表示:拒绝此用户(root)使用此密码访问mysql
解决方法:
修改root用户的密码。
具体步骤如下:
1.打开CMD,进入DOS命令窗口
2.切换目录到Mysql bin目录,如:cd D:\mysql-5.6.25-win32\bin
3.使用以下命令启动mysql服务:mysqld --skip-grant-tables。即跳过权限控制表启动mysql服务。此时,如果我们用客户端工具连接mysql是成功的。
4.将D:\mysql-5.6.25-win32\bin加入环境变量path中。另起一个DOS窗口。使用命令连接mysql
5.执行如下命令,修改root用户的密码为root3306:
sql>use mysqlsql>update user set password=PASSWORD('root3306') where user='root';sql>exit;
最后,重新启动Mysql服务即可。
0 0
- Mysql(Windows)--- 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)
- windows mysql提示:1045 access denied for user'root'@'localhost' using password yes
- linux下连接windows mysql的错误:Access denied for user 'root'@'localhost' (using password: YES)
- Windows系统下MySQL数据库出现Access denied for user 'root'@'localhost' (using password:YES) 错误
- windows mysql提示:1045 access denied for user 'root'@'localhost' using password yes 解决方案
- windows mysql提示:1045 access denied for user'root'@'localhost' using password yes
- mysql,windows平台下Access denied for user 'root'@'localhost' (using password:YES)
- windows mysql提示:1045 access denied for user 'root'@'localhost' using password yes 解决方案
- windows mysql提示:1045 access denied for user'root'@'localhost' using password yes
- MYSQL重置root密码(Access denied for user 'root'@'localhost' (using password: YES))
- MySql错误1045 Access denied for user 'root'@'localhost' (using password:YES) windows下的解决方案(忘记密码)
- jQuery UI
- Android中adb push和adb install的使用区别
- windows下使用VS2010编译jpeglib
- ios开发实用链接
- Spring 注释 @Autowired 和@Resource 的区别
- Mysql(Windows)--- Access denied for user 'root'@'localhost'(using password:YES)
- Quartus中出现错误: Can't place multiple pins assigned to pin location Pin_F16 (IOPAD_X53_Y21_N14)
- linux命令行下使用代理
- Activity的启动模式
- GRE写作必备句型
- Android源码之陌陌源码
- jsp学习笔记
- 对象的串行化(Serialization)
- android在指定区域监听滑动事件