1045-Access denied for user 'root'@'localhost'(using password:YES)解决方法
来源:互联网 发布:用指针求数组平均值 编辑:程序博客网 时间:2024/06/13 11:52
【问题所在】:未给root用户分配所有权限。
【解决步骤】:例如:用户名:aaa 密码:123456
一、打开 MySQL 5.5 Command Line Client 命令窗口:
Enter password:123456;
二、输入如下命令:grant all on *.* to aaa@‘%‘ identified by ‘123456‘;
mysql>grant all on *.* to aaa@‘%‘ identified by ‘123456‘; (记得在此语句后面加上英文的分号)
三、接着会出现:Query OK,0 rows affected <0.00 sec> 说明已经更改权限成功,问题解决了!!!
四、打开Navicat,双击localhost,不会再报错误了,此时可以进行操作,为所欲为了
【解决步骤】:例如:用户名:aaa 密码:123456
一、打开 MySQL 5.5 Command Line Client 命令窗口:
Enter password:123456;
二、输入如下命令:grant all on *.* to aaa@‘%‘ identified by ‘123456‘;
mysql>grant all on *.* to aaa@‘%‘ identified by ‘123456‘; (记得在此语句后面加上英文的分号)
三、接着会出现:Query OK,0 rows affected <0.00 sec> 说明已经更改权限成功,问题解决了!!!
四、打开Navicat,双击localhost,不会再报错误了,此时可以进行操作,为所欲为了
0 0
- 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)
- 1045 access denied for user 'root'@'localhost' using password yes
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 - Access denied for user 'root'@'localhost'(using password:YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 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) 1045
- 1045 access denied for user\'root\'@\'localhost\' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user ’root’@’localhost’ using password yes
- 使用Node.js拓展
- matlab-高数 判断是否为无穷大
- jquery基础语法
- 关于jFinal开发中遇到的中文乱码问题解决办法
- hdu 3549 Flow Problem(最大流,Edmond Karp)
- 1045-Access denied for user 'root'@'localhost'(using password:YES)解决方法
- matlab-高数 判断高阶无穷小
- 补间动画和逐帧动画结合之蝴蝶飞舞
- Java 修饰符
- volatile的应用
- 产品经理系列视频教程
- Dubbo&ZK分布式服务化改造(四)——Dubbo多注册中心 & 服务迁移
- 二叉树的遍历方法
- 研究HelixServer的一路风雨