user
Table comments: Users and global privileges
Column | Type | Null | Default | Comments |
Host
| char(60) | No | | |
User
| char(16) | No | | |
Password
| char(41) | 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) | Yes | | |
authentication_string
| text | Yes | NULL | |
password_expired
| enum('N', 'Y') | No | N | |
Indexes
No index defined!
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|
PRIMARY | BTREE | Yes | No | Host | | A | No | |
User | 4 | A | No |
Space usage:Data | 212 | B |
Index | 2,048 | B |
Total | 2,260 | B |
| |
Row Statistics:
Format | dynamic |
Rows | 4 |
Row length ø | 53 |
Row size ø | 565 B |
Creation | Mar 14, 2014 at 01:30 PM |
Last update | May 01, 2014 at 09:06 AM |
|