window下解决 ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
来源:互联网 发布:防范电信网络诈骗 编辑:程序博客网 时间:2024/05/04 16:37
最近在玩mysql, 期间碰到这个问题 - ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'。原因很清楚,mysql数据库的user表里,存在用户名为空的账户即匿名账户,导致登录的时候是虽然用的是root,但实际是匿名登录的,通过错误提示里的''@'localhost'可以看出来。 网上有一些linux下的解决方案。但我是在windows碰到的。解决方法如下:
1. 修改my.ini.在my.ini的[mysqld]字段加入,目的是为了登录mysql不需要密码:
skip-
grant
-tables
1
skip-
grant
-tables
2. 重启mysql 服务
3. 新开起一个终端输入
mysql -u root mysql
mysql> delete from user where USER='';
mysql> FLUSH PRIVILEGES;//记得要这句话,否则如果关闭先前的终端,又会出现原来的错误
mysql>exit;
参考文档: http://blog.csdn.net/tys1986blueboy/article/details/7056835/
0 0
- window下解决 ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- 解决ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- mysql报错:ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'ych'解决方式
- 如何解决ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database
- mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ubuntu mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- error 1044 (42000):access denied for user ''@'localhost' to database 'mysql'错误解决方案
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- IOS8,使用storyBoard对tableView的自适应
- mybatis如何使用延迟加载
- 解决无法创建模拟器问题的方法
- 数通畅联搬家啦
- Android App支付系列(二):支付宝SDK接入详细指南(附官方支付demo)
- window下解决 ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- 大学生可以参加的计算机比赛
- iOS开发中用手机和mac搭建IPv6测试环境
- 禁止形参未引用警告
- 光棍节的快乐
- Android开发艺术探索读书笔记(第3章 View的事件体系)
- springMVC 返回中文字符串时乱码
- Java IO:File 类
- 环境变量