ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
来源:互联网 发布:美国为何针对中国 知乎 编辑:程序博客网 时间:2024/06/05 22:53
最近用了新版解压版的mysql ,建立数据库的时候没有权限,root用户也没有密码 , 会提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 试了好多网上的解决方法都 没有解决。最后尝试了一种改法改好了。
1、use mysql数据库
2、select host,user,password user;
3、delete from user where user = ''; 删除''用户
4、update user set host = '%' where user = 'localhost'; 这句最重要
5、update user password =‘root’ where user = 'root'; 修改root的密码(可以不改)
0 0
- error: 'Access denied for user 'root'@'localhost' (using password: NO)'
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: no)
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) 的解决办法 ---linux
- ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)错误解决方法
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Lucene 自定义按距离排序
- Android学习笔记(04)——制作电话拨号器和短信发送器
- Zend 引擎执行器的核心代码
- 【Android】基于监听的事件处理和基于回调的事件处理
- android目录结构
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 第10001个素数
- tomcat多次部署项目导致memory leak
- 每天一句励志话2:孰能生巧,一遍不会,二遍、、、
- Linux内核大讲堂之设备驱动的基石驱动模型(7)
- 数组里a和&a的区别
- java 读取文件【转载】
- 笔记本亮度无法调节的可能原因
- UIScrollView分页的实现是这样子的