创了一个在aware_db库下只有select权限的用户,现在想用这个用户对aware_db下的device_table表做flush但提示需要reload权限, mysql> flush table aware_db.device_table; ERROR 1227 (42000): Access denied; you need the RELOAD privilege for this operation 切换到root用户授予该用户reload权限却失败了求大神帮忙 谢啦! mysql> grant RELOAD on aware_db.* to yikuaiwu@'%'identified by 'yikuaiwu';ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
0 reload 是 administrative 级的权限,即 server administration;这类权限包括: CREATE USER, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, SUPER 1 这类权限的授权不是针对某个数据库的,因此须使用on *.* 来进行: grant reload on *.* to 'test'@'localhost';