MySQL数据库安全配置(12) +-----------------+-----------------+------+-----+---------+-------+ 13 rows in set (0.01 sec)
db表列出数据库,而用户有权限访问它们。在这里指定的权限适用于一个数据库中的所有表。
mysql> desc host;
+-----------------+-----------------+------+-----+---------+-------+ Field Type Null Key Default Extra +-----------------+-----------------+------+-----+---------+-------+ Host char(60) binary PRI Db char(64) binary PRI Select_priv enum('N','Y') N Insert_priv enum('N','Y') N Update_priv enum('N','Y') N Delete_priv enum('N','Y') N Create_priv enum('N','Y') N Drop_priv enum('N','Y') N