mysql中解决:Error Code: 1044. Access denied for user 'root'@'%' to database
来源:互联网 发布:淘宝女装模特名字大全 编辑:程序博客网 时间:2024/06/06 01:40
来源:http://blog.csdn.net/odailidong/article/details/50770988
今天在测试集群用的MySQL上,遇到个权限的问题:
SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'ranger' ErrorCode: 1044
我是以root用户登录mysql的,怎么还会遇到这问题呢,有点猫腻,我查看了下mysql下user表的各用户的权限信息
mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;+--------------+---------+-------------------------------------------+------------+------------+| host | user | password | Grant_priv | Super_priv |+--------------+---------+-------------------------------------------+------------+------------+| 192.168.28.% | oozie | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N | Y || 192.168.28.% | hive | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N | Y || 192.168.28.% | root | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | Y | Y || localhost | ranger | *84BB87F6BF7F61703B24CE1C9AA9C0E3F2286900 | N | N || localhost | root | 0 | Y | Y || % | root | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N | Y || 127.0.0.1 | root | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | Y | Y || % | ranger | *84BB87F6BF7F61703B24CE1C9AA9C0E3F2286900 | N | Y |+--------------+---------+-------------------------------------------+------------+------------+
可以看到授权的权限没有打开: Grant_priv is set to N for root@%. 修复下
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';FLUSH PRIVILEGES;
重新登录下,就ok了。如果不能执行update的话,那就先停下mysql服务,然后mysqld_safe --skip-grant-table & (这个可以参考之前文章:http://blog.csdn.NET/oDaiLiDong/article/details/50196661),等改完之后再正常启动mysql
0 0
- mysql中解决:Error Code: 1044. Access denied for user 'root'@'%' to database
- Error Code: 1044. Access denied for user 'root'@'%' to database
- [解决] Error Code: 1044. Access denied for user 'root'@'%' to database
- [解决] Error Code: 1044. Access denied for user 'root'@'%' 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'
- CGI+MySQL: Access denied for user 'root'@'%' to database '
- 远程 mysql access denied for user 'root'@'%' to database xxxx
- MySQL Access denied for user 'root'@'%' to database 'xxx'
- ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
- 解决Access denied for user ''@'localhost' to database 'mysql
- 解决Access denied for user ''@'localhost' to database 'mysql'问题
- 解决ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- window下解决 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'
- mysql切换数据库时会报错:ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
- 冰冻花,被冻住的美丽
- JQury datatables 改变处理中 显示样式
- Fragment之间的跳转
- 解决ScollView嵌套ListView只显示一条的问题
- opencv中的图像亮度变换(图像增强)
- mysql中解决:Error Code: 1044. Access denied for user 'root'@'%' to database
- 欢迎使用CSDN-markdown编辑器
- Redis详细介绍
- spring源码解析-资源管理Resource
- Sql server 创建同义词CREATE SYNONYM介绍
- (转)WebView与JS交互和VedioView的简单使用
- JAVA 各种数值类型最大值和最小值 Int, short, char, long, float,&nbs
- HttpClient数据传输的编码方式
- VOIP听筒与扬声器的切换