mysql中user表和db表中存的权限有何不同？

Question

如以下两段sql：
“select user,host from mysql.user where(Select_priv=’Y’) or (Insert_priv=’Y’) or (Update_priv = ‘Y’) or (Delete_priv = ‘Y’) or (Create_priv = ‘Y’) or (Drop_priv = ‘Y’);”
“select user,host from mysql.db where db=’mysql’
and ((Select_priv=’Y’) or (Insert_priv=’Y’) or (Update_priv = ‘Y’) or (Delete_priv = ‘Y’) or (Create_priv = ‘Y’) or (Drop_priv = ‘Y’));”

Answer 1

user里面是登录到mysql数据库用户及其拥有的权限，db里面是针对数据库某个用户拥有的权限。主要对象不一样。