Table comments: Column privileges
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
Db (Primary) | char(64) | No | ||
User (Primary) | char(32) | No | ||
Table_name (Primary) | char(64) | No | ||
Column_name (Primary) | char(64) | No | ||
Timestamp | timestamp | No | CURRENT_TIMESTAMP | |
Column_priv | set('Select', 'Insert', 'Update', 'References') | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 0 | A | No | |
Db | 0 | A | No | |||||
User | 0 | A | No | |||||
Table_name | 0 | A | No | |||||
Column_name | 0 | A | No |
Table comments: Components
Column | Type | Null | Default | Comments |
---|---|---|---|---|
component_id (Primary) | int(10) | No | ||
component_group_id | int(10) | No | ||
component_urn | text | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | component_id | 0 | A | No |
Table comments: Database privileges
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
Db (Primary) | char(64) | No | ||
User (Primary) | char(32) | No | ||
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 | |
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 | |
Create_tmp_table_priv | enum('N', 'Y') | No | N | |
Lock_tables_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 | |
Execute_priv | enum('N', 'Y') | No | N | |
Event_priv | enum('N', 'Y') | No | N | |
Trigger_priv | enum('N', 'Y') | No | N |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 2 | A | No | |
Db | 5 | A | No | |||||
User | 5 | A | No | |||||
User | BTREE | No | No | User | 5 | A | No |
Table comments: Default roles
Column | Type | Null | Default | Comments |
---|---|---|---|---|
HOST (Primary) | char(255) | No | ||
USER (Primary) | char(32) | No | ||
DEFAULT_ROLE_HOST (Primary) | char(255) | No | % | |
DEFAULT_ROLE_USER (Primary) | char(32) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | HOST | 0 | A | No | |
USER | 0 | A | No | |||||
DEFAULT_ROLE_HOST | 0 | A | No | |||||
DEFAULT_ROLE_USER | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
engine_name (Primary) | varchar(64) | No | ||
device_type (Primary) | int(11) | No | ||
cost_name (Primary) | varchar(64) | No | ||
cost_value | float | Yes | NULL | |
last_update | timestamp | No | CURRENT_TIMESTAMP | |
comment | varchar(1024) | Yes | NULL | |
default_value | float | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | cost_name | 2 | A | No | |
engine_name | 2 | A | No | |||||
device_type | 2 | A | No |
Table comments: User defined functions
Column | Type | Null | Default | Comments |
---|---|---|---|---|
name (Primary) | char(64) | No | ||
ret | tinyint(1) | No | 0 | |
dl | char(128) | No | ||
type | enum('function', 'aggregate') | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | name | 0 | A | No |
Table comments: General log
Column | Type | Null | Default | Comments |
---|---|---|---|---|
event_time | timestamp(6) | No | CURRENT_TIMESTAMP(6) | |
user_host | mediumtext | No | ||
thread_id | bigint(21) | No | ||
server_id | int(10) | No | ||
command_type | varchar(64) | No | ||
argument | mediumblob | No |
No index defined!
Table comments: Extended global grants
Column | Type | Null | Default | Comments |
---|---|---|---|---|
USER (Primary) | char(32) | No | ||
HOST (Primary) | char(255) | No | ||
PRIV (Primary) | char(32) | No | ||
WITH_GRANT_OPTION | enum('N', 'Y') | No | N |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | USER | 2 | A | No | |
HOST | 4 | A | No | |||||
PRIV | 76 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
source_uuid (Primary) | char(36) | No | uuid of the source where the transaction was originally executed. | |
interval_start (Primary) | bigint(20) | No | First number of interval. | |
interval_end | bigint(20) | No | Last number of interval. |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | source_uuid | 0 | A | No | |
interval_start | 0 | A | No |
Table comments: help categories
Column | Type | Null | Default | Comments |
---|---|---|---|---|
help_category_id (Primary) | smallint(5) | No | ||
name | char(64) | No | ||
parent_category_id | smallint(5) | Yes | NULL | |
url | text | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | help_category_id | 44 | A | No | |
name | BTREE | Yes | No | name | 44 | A | No |
Table comments: help keywords
Column | Type | Null | Default | Comments |
---|---|---|---|---|
help_keyword_id (Primary) | int(10) | No | ||
name | char(64) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | help_keyword_id | 726 | A | No | |
name | BTREE | Yes | No | name | 701 | A | No |
Table comments: keyword-topic relation
Column | Type | Null | Default | Comments |
---|---|---|---|---|
help_topic_id (Primary) | int(10) | No | ||
help_keyword_id (Primary) | int(10) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | help_keyword_id | 734 | A | No | |
help_topic_id | 1837 | A | No |
Table comments: help topics
Column | Type | Null | Default | Comments |
---|---|---|---|---|
help_topic_id (Primary) | int(10) | No | ||
name | char(64) | No | ||
help_category_id | smallint(5) | No | ||
description | text | No | ||
example | text | No | ||
url | text | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | help_topic_id | 465 | A | No | |
name | BTREE | Yes | No | name | 465 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
database_name (Primary) | varchar(64) | No | ||
table_name (Primary) | varchar(199) | No | ||
index_name (Primary) | varchar(64) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP | |
stat_name (Primary) | varchar(64) | No | ||
stat_value | bigint(20) | No | ||
sample_size | bigint(20) | Yes | NULL | |
stat_description | varchar(1024) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | database_name | 27 | A | No | |
table_name | 76 | A | No | |||||
index_name | 98 | A | No | |||||
stat_name | 346 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
database_name (Primary) | varchar(64) | No | ||
table_name (Primary) | varchar(199) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP | |
n_rows | bigint(20) | No | ||
clustered_index_size | bigint(20) | No | ||
sum_of_other_index_sizes | bigint(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | database_name | 20 | A | No | |
table_name | 60 | A | No |
Table comments: Password history for user accounts
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
User (Primary) | char(32) | No | ||
Password_timestamp (Primary) | timestamp(6) | No | CURRENT_TIMESTAMP(6) | |
Password | text | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 0 | A | No | |
User | 0 | A | No | |||||
Password_timestamp | 0 | D | No |
Table comments: MySQL plugins
Column | Type | Null | Default | Comments |
---|---|---|---|---|
name (Primary) | varchar(64) | No | ||
dl | varchar(128) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | name | 1 | A | No |
Table comments: Procedure privileges
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
Db (Primary) | char(64) | No | ||
User (Primary) | char(32) | No | ||
Routine_name (Primary) | char(64) | No | ||
Routine_type (Primary) | enum('FUNCTION', 'PROCEDURE') | No | ||
Grantor | varchar(288) | No | ||
Proc_priv | set('Execute', 'Alter Routine', 'Grant') | No | ||
Timestamp | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 0 | A | No | |
Db | 0 | A | No | |||||
User | 0 | A | No | |||||
Routine_name | 0 | A | No | |||||
Routine_type | 0 | A | No | |||||
Grantor | BTREE | No | No | Grantor | 0 | A | No |
Table comments: User proxy privileges
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
User (Primary) | char(32) | No | ||
Proxied_host (Primary) | char(255) | No | ||
Proxied_user (Primary) | char(32) | No | ||
With_grant | tinyint(1) | No | 0 | |
Grantor | varchar(288) | No | ||
Timestamp | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 1 | A | No | |
User | 1 | A | No | |||||
Proxied_host | 1 | A | No | |||||
Proxied_user | 1 | A | No | |||||
Grantor | BTREE | No | No | Grantor | 1 | A | No |
Table comments: Role hierarchy and role grants
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FROM_HOST (Primary) | char(255) | No | ||
FROM_USER (Primary) | char(32) | No | ||
TO_HOST (Primary) | char(255) | No | ||
TO_USER (Primary) | char(32) | No | ||
WITH_ADMIN_OPTION | enum('N', 'Y') | No | N |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | FROM_HOST | 0 | A | No | |
FROM_USER | 0 | A | No | |||||
TO_HOST | 0 | A | No | |||||
TO_USER | 0 | A | No |
Table comments: MySQL Foreign Servers table
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Server_name (Primary) | char(64) | No | ||
Host | char(255) | No | ||
Db | char(64) | No | ||
Username | char(64) | No | ||
Password | char(64) | No | ||
Port | int(4) | No | 0 | |
Socket | char(64) | No | ||
Wrapper | char(64) | No | ||
Owner | char(64) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Server_name | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
cost_name (Primary) | varchar(64) | No | ||
cost_value | float | Yes | NULL | |
last_update | timestamp | No | CURRENT_TIMESTAMP | |
comment | varchar(1024) | Yes | NULL | |
default_value | float | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | cost_name | 6 | A | No |
Table comments: Master Information
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Number_of_lines | int(10) | No | Number of lines in the file. | |
Master_log_name | text | No | The name of the master binary log currently being read from the master. | |
Master_log_pos | bigint(20) | No | The master log position of the last read event. | |
Host | char(255) | Yes | NULL | The host name of the master. |
User_name | text | Yes | NULL | The user name used to connect to the master. |
User_password | text | Yes | NULL | The password used to connect to the master. |
Port | int(10) | No | The network port used to connect to the master. | |
Connect_retry | int(10) | No | The period (in seconds) that the slave will wait before trying to reconnect to the master. | |
Enabled_ssl | tinyint(1) | No | Indicates whether the server supports SSL connections. | |
Ssl_ca | text | Yes | NULL | The file used for the Certificate Authority (CA) certificate. |
Ssl_capath | text | Yes | NULL | The path to the Certificate Authority (CA) certificates. |
Ssl_cert | text | Yes | NULL | The name of the SSL certificate file. |
Ssl_cipher | text | Yes | NULL | The name of the cipher in use for the SSL connection. |
Ssl_key | text | Yes | NULL | The name of the SSL key file. |
Ssl_verify_server_cert | tinyint(1) | No | Whether to verify the server certificate. | |
Heartbeat | float | No | ||
Bind | text | Yes | NULL | Displays which interface is employed when connecting to the MySQL server |
Ignored_server_ids | text | Yes | NULL | The number of server IDs to be ignored, followed by the actual server IDs |
Uuid | text | Yes | NULL | The master server uuid. |
Retry_count | bigint(20) | No | Number of reconnect attempts, to the master, before giving up. | |
Ssl_crl | text | Yes | NULL | The file used for the Certificate Revocation List (CRL) |
Ssl_crlpath | text | Yes | NULL | The path used for Certificate Revocation List (CRL) files |
Enabled_auto_position | tinyint(1) | No | Indicates whether GTIDs will be used to retrieve events from the master. | |
Channel_name (Primary) | char(64) | No | The channel on which the slave is connected to a source. Used in Multisource Replication | |
Tls_version | text | Yes | NULL | Tls version |
Public_key_path | text | Yes | NULL | The file containing public key of master server. |
Get_public_key | tinyint(1) | No | Preference to get public key from master. | |
Network_namespace | text | Yes | NULL | Network namespace used for communication with the master server. |
Master_compression_algorithm | char(64) | No | Compression algorithm supported for data transfer between master and slave. | |
Master_zstd_compression_level | int(10) | No | Compression level associated with zstd compression algorithm. |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Channel_name | 0 | A | No |
Table comments: Relay Log Information
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Number_of_lines | int(10) | No | Number of lines in the file or rows in the table. Used to version table definitions. | |
Relay_log_name | text | No | The name of the current relay log file. | |
Relay_log_pos | bigint(20) | No | The relay log position of the last executed event. | |
Master_log_name | text | No | The name of the master binary log file from which the events in the relay log file were read. | |
Master_log_pos | bigint(20) | No | The master log position of the last executed event. | |
Sql_delay | int(11) | No | The number of seconds that the slave must lag behind the master. | |
Number_of_workers | int(10) | No | ||
Id | int(10) | No | Internal Id that uniquely identifies this record. | |
Channel_name (Primary) | char(64) | No | The channel on which the slave is connected to a source. Used in Multisource Replication | |
Privilege_checks_username | char(32) | Yes | NULL | Username part of PRIVILEGE_CHECKS_USER. |
Privilege_checks_hostname | char(255) | Yes | NULL | Hostname part of PRIVILEGE_CHECKS_USER. |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Channel_name | 0 | A | No |
Table comments: Worker Information
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Id (Primary) | int(10) | No | ||
Relay_log_name | text | No | ||
Relay_log_pos | bigint(20) | No | ||
Master_log_name | text | No | ||
Master_log_pos | bigint(20) | No | ||
Checkpoint_relay_log_name | text | No | ||
Checkpoint_relay_log_pos | bigint(20) | No | ||
Checkpoint_master_log_name | text | No | ||
Checkpoint_master_log_pos | bigint(20) | No | ||
Checkpoint_seqno | int(10) | No | ||
Checkpoint_group_size | int(10) | No | ||
Checkpoint_group_bitmap | blob | No | ||
Channel_name (Primary) | char(64) | No | The channel on which the slave is connected to a source. Used in Multisource Replication |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Channel_name | 0 | A | No | |
Id | 0 | A | No |
Table comments: Slow log
Column | Type | Null | Default | Comments |
---|---|---|---|---|
start_time | timestamp(6) | No | CURRENT_TIMESTAMP(6) | |
user_host | mediumtext | No | ||
query_time | time(6) | No | ||
lock_time | time(6) | No | ||
rows_sent | int(11) | No | ||
rows_examined | int(11) | No | ||
db | varchar(512) | No | ||
last_insert_id | int(11) | No | ||
insert_id | int(11) | No | ||
server_id | int(10) | No | ||
sql_text | mediumblob | No | ||
thread_id | bigint(21) | No |
No index defined!
Table comments: Table privileges
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
Db (Primary) | char(64) | No | ||
User (Primary) | char(32) | No | ||
Table_name (Primary) | char(64) | No | ||
Grantor | varchar(288) | No | ||
Timestamp | timestamp | No | CURRENT_TIMESTAMP | |
Table_priv | set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger') | No | ||
Column_priv | set('Select', 'Insert', 'Update', 'References') | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 1 | A | No | |
Db | 2 | A | No | |||||
User | 2 | A | No | |||||
Table_name | 2 | A | No | |||||
Grantor | BTREE | No | No | Grantor | 2 | A | No |
Table comments: Time zones
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Time_zone_id (Primary) | int(10) | No | ||
Use_leap_seconds | enum('Y', 'N') | No | N |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Time_zone_id | 0 | A | No |
Table comments: Leap seconds information for time zones
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Transition_time (Primary) | bigint(20) | No | ||
Correction | int(11) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Transition_time | 0 | A | No |
Table comments: Time zone names
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Name (Primary) | char(64) | No | ||
Time_zone_id | int(10) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Name | 0 | A | No |
Table comments: Time zone transitions
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Time_zone_id (Primary) | int(10) | No | ||
Transition_time (Primary) | bigint(20) | No | ||
Transition_type_id | int(10) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Time_zone_id | 0 | A | No | |
Transition_time | 0 | A | No |
Table comments: Time zone transition types
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Time_zone_id (Primary) | int(10) | No | ||
Transition_type_id (Primary) | int(10) | No | ||
Offset | int(11) | No | 0 | |
Is_DST | tinyint(3) | No | 0 | |
Abbreviation | char(8) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Time_zone_id | 0 | A | No | |
Transition_type_id | 0 | A | No |
Table comments: Users and global privileges
Column | Type | Null | Default | Comments |
---|---|---|---|---|
Host (Primary) | char(255) | No | ||
User (Primary) | char(32) | No | ||
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 | ||
x509_issuer | blob | No | ||
x509_subject | blob | No | ||
max_questions | int(11) | No | 0 | |
max_updates | int(11) | No | 0 | |
max_connections | int(11) | No | 0 | |
max_user_connections | int(11) | 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(5) | 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(5) | Yes | NULL | |
Password_reuse_time | smallint(5) | Yes | NULL | |
Password_require_current | enum('N', 'Y') | Yes | NULL | |
User_attributes | json | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Host | 2 | A | No | |
User | 9 | A | No |