Properties

Engine: MyISAM 
Row format:
Rows: Dynamic 
Avg row length:
Data length: 88 
Max data length: 216 
Index length: 4294967295 
Data free: 2048 
Auto increment: 40 
Create time:  
Update time: 2006/19/07/2006 
Check time: 2006/18/11/2006 
Create_options:  
Comment: utf8_bin 

Columns

Name Data Type NULL Default
    Host  varchar(60)    PRI 
    User  varchar(16)    PRI 
    Password  varchar(41)     
    Select_priv  enum('N', 'Y')     
    Insert_priv  enum('N', 'Y')     
    Update_priv  enum('N', 'Y')     
    Delete_priv  enum('N', 'Y')     
    Create_priv  enum('N', 'Y')     
    Drop_priv  enum('N', 'Y')     
    Reload_priv  enum('N', 'Y')     
    Shutdown_priv  enum('N', 'Y')     
    Process_priv  enum('N', 'Y')     
    File_priv  enum('N', 'Y')     
    Grant_priv  enum('N', 'Y')     
    References_priv  enum('N', 'Y')     
    Index_priv  enum('N', 'Y')     
    Alter_priv  enum('N', 'Y')     
    Show_db_priv  enum('N', 'Y')     
    Super_priv  enum('N', 'Y')     
    Create_tmp_table_priv  enum('N', 'Y')     
    Lock_tables_priv  enum('N', 'Y')     
    Execute_priv  enum('N', 'Y')     
    Repl_slave_priv  enum('N', 'Y')     
    Repl_client_priv  enum('N', 'Y')     
    ssl_type  enum('', 'ANY', 'X509', 'SPECIFIED')     
    ssl_cipher  blob     
    x509_issuer  blob     
    x509_subject  blob     
    max_questions  int(11) unsigned     
    max_updates  int(11) unsigned     
    max_connections  int(11) unsigned     
Total: 31 column(s)

Indexes

Name Primary Unique
  PRIMARY     
Total: 1 indexes(s)

SQL

CREATE TABLE `user` (
  `Host` varchar(60) collate utf8_bin NOT NULL default '',
  `User` varchar(16) collate utf8_bin NOT NULL default '',
  `Password` varchar(41) collate utf8_bin NOT NULL default '',
  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL default '0',
  `max_updates` int(11) unsigned NOT NULL default '0',
  `max_connections` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'

See Also

List of tables