Access denied for user 'root'@'%' to database 'ranger' ErrorCode: 1044
来源:互联网 发布:一句话经典 知乎 编辑:程序博客网 时间:2024/06/09 20:24
1、创建用户时报错
2、查看权限
mysql> SELECT host,user,authentication_string,Grant_priv,Super_priv FROM mysql.user;
可以看到授权的权限没有打开,修复下
3、打开权限
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
4、重新创建用户即可;
mysql> grant select on lon.* to 'dataddd'@'%' identified by 'Baaadi';
ERROR 1044 (42000): Access denied for user 'loan'@'%' to database 'lon'
mysql>
2、查看权限
mysql> SELECT host,user,authentication_string,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 |+--------------+---------+-------------------------------------------+------------+------------+
mysql> 可以看到授权的权限没有打开,修复下
3、打开权限
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
4、重新创建用户即可;
阅读全文
0 0
- Access denied for user 'root'@'%' to database 'ranger' ErrorCode: 1044
- ranger启动报错Access denied for user 'root'@'%' to database 'ranger'
- 1044-Access denied for user 'root'@'%' to database databaseTest 错误
- CGI+MySQL: Access denied for user 'root'@'%' to database '
- 远程 mysql access denied for user 'root'@'%' to database xxxx
- Access denied for user 'root'@'192.168.12.249' to database 'zc_beauty'
- Access denied for user 'root'@'localhost' to database
- MySQL Access denied for user 'root'@'%' to database 'xxx'
- 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'
- ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'test'
- mysql错误1044-Access denied for user 'root'@'localhost' to database
- ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user 'root'@'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
- 并查集
- 对Java中的深复制和浅复制的一些理解
- 迷宫大门
- c++ sort函数的用法
- golang http 编程-1(服务器编程)
- Access denied for user 'root'@'%' to database 'ranger' ErrorCode: 1044
- 13、二叉搜索树-AVL树
- 正则表达式匹配
- 数据结构-循环列表
- python3.6+mysql无法写入中文问题
- DBMS_SHARED_POOL包将对象固定到共享池 .
- Java死锁问题分析
- OJ text2 括号匹配问题
- 51nod-1085 背包问题【01背包】