Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Host | CHAR | 255 |
|
|
||||
| User | CHAR | 32 |
|
|
||||
| Select_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Insert_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Update_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Delete_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Drop_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Reload_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Shutdown_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Process_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| File_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Grant_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| References_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Index_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Alter_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Show_db_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Super_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_tmp_table_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Lock_tables_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Execute_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Repl_slave_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Repl_client_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_view_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Show_view_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_routine_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Alter_routine_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_user_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Event_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Trigger_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_tablespace_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| ssl_type | enum('', 'ANY', 'X509', 'SPECIFIED') | 9 |
|
|
||||
| ssl_cipher | BLOB | 65535 | null |
|
|
|||
| x509_issuer | BLOB | 65535 | null |
|
|
|||
| x509_subject | BLOB | 65535 | null |
|
|
|||
| max_questions | INT UNSIGNED | 10 | 0 |
|
|
|||
| max_updates | INT UNSIGNED | 10 | 0 |
|
|
|||
| max_connections | INT UNSIGNED | 10 | 0 |
|
|
|||
| max_user_connections | INT UNSIGNED | 10 | 0 |
|
|
|||
| plugin | CHAR | 64 | caching_sha2_password |
|
|
|||
| authentication_string | TEXT | 65535 | √ | null |
|
|
||
| password_expired | enum('N', 'Y') | 1 | N |
|
|
|||
| password_last_changed | TIMESTAMP | 19 | √ | null |
|
|
||
| password_lifetime | SMALLINT UNSIGNED | 5 | √ | null |
|
|
||
| account_locked | enum('N', 'Y') | 1 | N |
|
|
|||
| Create_role_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Drop_role_priv | enum('N', 'Y') | 1 | N |
|
|
|||
| Password_reuse_history | SMALLINT UNSIGNED | 5 | √ | null |
|
|
||
| Password_reuse_time | SMALLINT UNSIGNED | 5 | √ | null |
|
|
||
| Password_require_current | enum('N', 'Y') | 1 | √ | null |
|
|
||
| User_attributes | JSON | 1073741824 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | Host + User |
Relationships
Close relationships within degrees of separation
