MariaDB的mysql.user表被误删除

andy27367451

MariaDB [mysql]>create table `user` (　　
  `Host` char(60) collate utf8_bin NOT NULL default '',
　　
  `User` char(16) collate utf8_bin NOT NULL default '',
　　
  `Password` char(41) character set latin1 collate latin1_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',
　　
  `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
　　
  `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
　　
  `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
　　
  `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
　　
  `Create_user_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
　　
  `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL defau
　　
lt '',
　　
  `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',
　　
  `max_user_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';