ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
来源:互联网 发布:木马编程教学 编辑:程序博客网 时间:2024/06/06 03:07
环境介绍:
Centos 6.X
数据库:MariaDB5.5.-10.1.13
手动更改MySQL密码后,提示如下报错ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
root cause:
mysql数据库的user表里,存在用户名为空的账户可以视为匿名账户,导致登录的时候是虽然输入的是root,但实际用匿名登录的;
解决办法:
在my.cnf的[mysqld]字段加入:
skip-grant-tables
重启mysql服务,然后进入mysql
mysql>use mysql;
mysql>update user set password=password('新密码') WHERE User='root';
mysql>flush privileges;
运行之后最后去掉my.cnf中的skip-grant-tables,重启mysqld即可。
2 0
- 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'
- 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'
- Java设置session时长
- mqtt 推送的客户端测试方法
- 提升AngularJS性能的11条建议
- android 状态栏(StatusBar)
- 37. Sudoku Solver
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- linux怎样修改主机名
- tableView代理方法的调用时间,(主要是heightForRowAtIndexPath和cellForRowAtIndexPath调用时间)
- MyBatis学习总结(五)——实现关联表查询
- 第八周-不止有一件武器
- Android之有效防止按钮多次重复点击
- 解决ubuntu无法调整和保存屏幕亮度的问题
- Unity优化个人体验
- iOS图文混排(需要在文本或者字符串中某些特定位置添加文本框)