ERROR 1045 (28000): Access denied for user ‘aa‘@‘localhost‘ to database dd

一：问题描述

用root用户授权报错：

mysql> grant select on *.* to 'jiao';

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

用root外的其他用户授权报错具体到了数据库：

ERROR 1044 (42000) at line 4: Access denied for user 'aar'@'%' to database 'dd';

二：出错原因

该用户没有授权权限

三：解决办法

mysql> update mysql.user set Grant_Priv='Y' where user='root' and host='localhost';

mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)

或者通过grant ... with grant option;

退出后重新登录，再次授权即可

grant select on *.* to 'jiao';