Mysql约束和默认Default---mysql.db

最新推荐文章于 2024-04-03 13:45:04 发布

原创最新推荐文章于 2024-04-03 13:45:04 发布 · 186 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL

JAVA 专栏收录该内容

332 篇文章

订阅专栏

本文详细解析了MySQL数据库中权限表的结构与字段含义，包括各权限字段的数据类型、默认值及所允许的操作等，为理解MySQL的安全管理和权限分配提供基础。

/*Column Information For - mysql.db*/
-------------------------------------

Field Type Collation Null Key Default Extra Privileges Comment
--------------------- ------------- --------------- ------ ------ ------- ------ ------------------------------- -------
Host char(60) utf8_bin NO PRI select,insert,update,references
Db char(64) utf8_bin NO PRI select,insert,update,references
User char(16) utf8_bin NO PRI select,insert,update,references
Select_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Insert_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Update_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Delete_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Create_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Drop_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Grant_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
References_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Index_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Alter_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Create_tmp_table_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Lock_tables_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Create_view_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Show_view_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Create_routine_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Alter_routine_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Execute_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Event_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references
Trigger_priv enum('N','Y') utf8_general_ci NO N select,insert,update,references

/*Index Information For - mysql.db*/
------------------------------------

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
------ ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- -------
db 0 PRIMARY 1 Host A (NULL) (NULL) (NULL) BTREE
db 0 PRIMARY 2 Db A (NULL) (NULL) (NULL) BTREE
db 0 PRIMARY 3 User A 0 (NULL) (NULL) BTREE
db 1 User 1 User A 0 (NULL) (NULL) BTREE

/*DDL Information For - mysql.db*/
----------------------------------

Table Create Table
------ -------------------------------------------------------------------------------------
db CREATE TABLE `db` (
`Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
`Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
`Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
`Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
PRIMARY KEY (`Host`,`Db`,`User`),
KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'