| Alter | Alter_priv | 允许用alter语句修改表结构。 |
+-----------+-------------+-----------------------------------------------------------------------+
| Grant | Grant_priv | 允许将自己拥有的权限授予其它用户，包括grant。 |
+-----------+-------------+-----------------------------------------------------------------------+
| Reload | Reload | 允许重载授权表，刷新服务器等命令。 |
+-----------+-------------+-----------------------------------------------------------------------+
| Shutdown | Shudown_priv| 允许用mysqladmin shutdown命令关闭MySQL服务器。该权限比较危险， |
| | | 不应该随便授予。 |
+-----------+-------------+-----------------------------------------------------------------------+
| Process | Process_priv| 允许查看和终止MySQL服务器正在运行的线程（进程）以及正在执行的查询语句 |
| | | ，包括执行修改密码的查询语句。该权限比较危险，不应该随便授予。 |
+-----------+-------------+-----------------------------------------------------------------------+ | File | File_priv | 允许从服务器上读全局可读文件和写文件。该权限比较危险，不应该随便授予。| +-----------+-------------+-----------------------------------------------------------------------+
mysql> desc db;
+-----------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+ | Host | char(60) binary | | PRI | | | | Db | char(64) binary | | PRI | | |
| User | char(16) 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 | |
| Grant_priv | enum(‘N‘,‘Y‘) | | | N | |
| References_priv | enum(‘N‘,‘Y‘) | | | N | |
| Index_priv | enum(‘N‘,‘Y‘) | | | N | |
| Alter_priv | enum(‘N‘,‘Y‘) | | | N | |
+---
