MySQL--显示表的相关信息
C:\Users\Administrator>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.40 MySQL Community Server - GPL
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show table status like 'user';
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Database changed
mysql> show table status like 'user';
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+---------------------------------------+-----------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+---------------------------------------+-----------------------------+
| user | InnoDB | 10 | Dynamic | 5 | 3276 | 16384 | 0 | 0 | 4194304 | NULL | 2025-01-25 18:24:05 | NULL | NULL | utf8mb3_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Users and global privileges |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+---------------------------------------+-----------------------------+
1 row in set (0.02 sec)
mysql> descrip user;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'descrip user' at line 1
mysql> describe user;
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host | char(255) | NO | PRI | | |
| User | char(32) | NO | PRI | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int unsigned | NO | | 0 | |
| max_updates | int unsigned | NO | | 0 | |
| max_connections | int unsigned | NO | | 0 | |
| max_user_connections | int unsigned | NO | | 0 | |
| plugin | char(64) | NO | | caching_sha2_password | |
| authentication_string | text | YES | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
| password_last_changed | timestamp | YES | | NULL | |
| password_lifetime | smallint unsigned | YES | | NULL | |
| account_locked | enum('N','Y') | NO | | N | |
| Create_role_priv | enum('N','Y') | NO | | N | |
| Drop_role_priv | enum('N','Y') | NO | | N | |
| Password_reuse_history | smallint unsigned | YES | | NULL | |
| Password_reuse_time | smallint unsigned | YES | | NULL | |
| Password_require_current | enum('N','Y') | YES | | NULL | |
| User_attributes | json | YES | | NULL | |
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
51 rows in set (0.01 sec)
mysql> show columns from user;
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host | char(255) | NO | PRI | | |
| User | char(32) | NO | PRI | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int unsigned | NO | | 0 | |
| max_updates | int unsigned | NO | | 0 | |
| max_connections | int unsigned | NO | | 0 | |
| max_user_connections | int unsigned | NO | | 0 | |
| plugin | char(64) | NO | | caching_sha2_password | |
| authentication_string | text | YES | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
| password_last_changed | timestamp | YES | | NULL | |
| password_lifetime | smallint unsigned | YES | | NULL | |
| account_locked | enum('N','Y') | NO | | N | |
| Create_role_priv | enum('N','Y') | NO | | N | |
| Drop_role_priv | enum('N','Y') | NO | | N | |
| Password_reuse_history | smallint unsigned | YES | | NULL | |
| Password_reuse_time | smallint unsigned | YES | | NULL | |
| Password_require_current | enum('N','Y') | YES | | NULL | |
| User_attributes | json | YES | | NULL | |
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
51 rows in set (0.00 sec)
mysql> show create table user;
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| user | CREATE TABLE `user` (
`Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
`User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
`Select_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Insert_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Update_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Delete_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Drop_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Reload_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Shutdown_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Process_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`File_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Grant_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`References_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Index_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Alter_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Show_db_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Super_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Lock_tables_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Execute_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Repl_slave_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Repl_client_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Show_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Alter_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_user_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Event_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Trigger_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
`ssl_cipher` blob NOT NULL,
`x509_issuer` blob NOT NULL,
`x509_subject` blob NOT NULL,
`max_questions` int unsigned NOT NULL DEFAULT '0',
`max_updates` int unsigned NOT NULL DEFAULT '0',
`max_connections` int unsigned NOT NULL DEFAULT '0',
`max_user_connections` int unsigned NOT NULL DEFAULT '0',
`plugin` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT 'caching_sha2_password',
`authentication_string` text COLLATE utf8mb3_bin,
`password_expired` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`password_last_changed` timestamp NULL DEFAULT NULL,
`password_lifetime` smallint unsigned DEFAULT NULL,
`account_locked` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Create_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Drop_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
`Password_reuse_history` smallint unsigned DEFAULT NULL,
`Password_reuse_time` smallint unsigned DEFAULT NULL,
`Password_require_current` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`User_attributes` json DEFAULT NULL,
PRIMARY KEY (`Host`,`User`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Users and global privileges' |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql> select * from columns where table_name = 'user';
ERROR 3554 (HY000): Access to data dictionary table 'mysql.columns' is rejected.
mysql> select * from information_schema.columns where table_name = 'user';
+---------------+--------------+------------+--------------------------+------------------+-----------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+-----------------------------------+------------+-------+---------------------------------+----------------+-----------------------+--------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | GENERATION_EXPRESSION | SRS_ID |
+---------------+--------------+------------+--------------------------+------------------+-----------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+-----------------------------------+------------+-------+---------------------------------+----------------+-----------------------+--------+
| def | mysql | user | account_locked | 45 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Alter_priv | 16 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Alter_routine_priv | 27 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | authentication_string | 41 | NULL | YES | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb3 | utf8mb3_bin | text | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_priv | 7 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_role_priv | 46 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_routine_priv | 26 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_tablespace_priv | 31 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_tmp_table_priv | 19 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_user_priv | 28 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Create_view_priv | 24 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Delete_priv | 6 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Drop_priv | 8 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Drop_role_priv | 47 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Event_priv | 29 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Execute_priv | 21 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | File_priv | 12 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Grant_priv | 13 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Host | 1 | | NO | char | 255 | 255 | NULL | NULL | NULL | ascii | ascii_general_ci | char(255) | PRI | | select,insert,update,references | | | NULL |
| def | mysql | user | Index_priv | 15 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Insert_priv | 4 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Lock_tables_priv | 20 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | max_connections | 38 | 0 | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | max_questions | 36 | 0 | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | max_updates | 37 | 0 | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | max_user_connections | 39 | 0 | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | password_expired | 42 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | password_last_changed | 43 | NULL | YES | timestamp | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timestamp | | | select,insert,update,references | | | NULL |
| def | mysql | user | password_lifetime | 44 | NULL | YES | smallint | NULL | NULL | 5 | 0 | NULL | NULL | NULL | smallint unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | Password_require_current | 50 | NULL | YES | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Password_reuse_history | 48 | NULL | YES | smallint | NULL | NULL | 5 | 0 | NULL | NULL | NULL | smallint unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | Password_reuse_time | 49 | NULL | YES | smallint | NULL | NULL | 5 | 0 | NULL | NULL | NULL | smallint unsigned | | | select,insert,update,references | | | NULL |
| def | mysql | user | plugin | 40 | caching_sha2_password | NO | char | 64 | 192 | NULL | NULL | NULL | utf8mb3 | utf8mb3_bin | char(64) | | | select,insert,update,references | | | NULL |
| def | mysql | user | Process_priv | 11 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | References_priv | 14 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Reload_priv | 9 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Repl_client_priv | 23 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Repl_slave_priv | 22 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Select_priv | 3 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Show_db_priv | 17 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Show_view_priv | 25 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Shutdown_priv | 10 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | ssl_cipher | 33 | NULL | NO | blob | 65535 | 65535 | NULL | NULL | NULL | NULL | NULL | blob | | | select,insert,update,references | | | NULL |
| def | mysql | user | ssl_type | 32 | | NO | enum | 9 | 27 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('','ANY','X509','SPECIFIED') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Super_priv | 18 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Trigger_priv | 30 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | Update_priv | 5 | N | NO | enum | 1 | 3 | NULL | NULL | NULL | utf8mb3 | utf8mb3_general_ci | enum('N','Y') | | | select,insert,update,references | | | NULL |
| def | mysql | user | User | 2 | | NO | char | 32 | 96 | NULL | NULL | NULL | utf8mb3 | utf8mb3_bin | char(32) | PRI | | select,insert,update,references | | | NULL |
| def | mysql | user | User_attributes | 51 | NULL | YES | json | NULL | NULL | NULL | NULL | NULL | NULL | NULL | json | | | select,insert,update,references | | | NULL |
| def | mysql | user | x509_issuer | 34 | NULL | NO | blob | 65535 | 65535 | NULL | NULL | NULL | NULL | NULL | blob | | | select,insert,update,references | | | NULL |
| def | mysql | user | x509_subject | 35 | NULL | NO | blob | 65535 | 65535 | NULL | NULL | NULL | NULL | NULL | blob | | | select,insert,update,references | | | NULL |
+---------------+--------------+------------+--------------------------+------------------+-----------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+-----------------------------------+------------+-------+---------------------------------+----------------+-----------------------+--------+
51 rows in set (0.01 sec)
mysql>
分类:
自用 / 高性能MySQL
标签:
MySQL
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 震惊！C++程序真的从main开始吗？99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码？零基础破解AI编程运行原理
· 单元测试从入门到精通
· 上周热点回顾（3.3-3.9）
· winform 绘制太阳，地球，月球 运作规律