[Err] 1044
来源:互联网 发布:linux系统下删除用户 编辑:程序博客网 时间:2024/06/05 13:26
1、创建用户时报错
grant select on lon.* to 'data'@'%' identified by 'Bi';
[Err] 1044 - Access denied for user 'lon'@'%' to database 'lon'
以root用户登录mysql的,怎么还会遇到这问题
2、查看权限
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@%. 修复下
3、打开权限
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';FLUSH PRIVILEGES; 4、重新创建用户即可;
阅读全文
0 0
- [Err] 1044
- Err 对象
- err.c
- fastjson-err
- [Err] 1055
- [Err] 42000
- [Err] 23000
- [Err] 1091
- [Err] 1690
- [Err] 1205
- Java_log2000_System.err
- [Err] 2013
- [Err] 1022
- [Err] 1055
- [Err] 1449
- [Err] 1293
- [Err] 1062
- [Err] 1064
- 扔掉KVM!图解戴尔iDRAC服务器远程控制设置
- cocos2d-x使用之调用系统消息框CCMessageBox
- 理解Windows内核模式与用户模式(新)
- centos7 下Nginx安装配置
- Android Studio 开发常遇到的SDK版本的问题
- [Err] 1044
- 1090. Highest Price in Supply Chain (25)
- android将一个long型转成时间字符串
- 刷LeetCode(1)——两数相加
- 取随机数的两种方法
- IntelliJ IDEA 实用快捷键
- Matlab plot函数
- python字典
- es 基本语法 使用 案例