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 |
|