MySQL是一款關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，它支持多用戶同時(shí)訪問同一個(gè)數(shù)據(jù)庫。其中，用戶信息存儲(chǔ)在user表中。當(dāng)我們創(chuàng)建一個(gè)新的MySQL實(shí)例時(shí)，系統(tǒng)會(huì)默認(rèn)創(chuàng)建一個(gè)MySQL數(shù)據(jù)庫，并在這個(gè)數(shù)據(jù)庫中創(chuàng)建user表。

但有些時(shí)候，我們可能需要?jiǎng)?chuàng)建一個(gè)MySQL實(shí)例，但并不需要默認(rèn)的MySQL數(shù)據(jù)庫。這種情況下，我們就需要手動(dòng)創(chuàng)建一個(gè)user表，并將用戶信息存儲(chǔ)在這個(gè)表中。

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',
`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',
`max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
`plugin` char(64) COLLATE utf8_bin DEFAULT '',
`authentication_string` text COLLATE utf8_bin,
`password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
PRIMARY KEY (`host`,`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

上述代碼就是創(chuàng)建一個(gè)MySQL user表的語句，其中包含了用戶的各種權(quán)限和信息。

總之，創(chuàng)建一個(gè)自定義的MySQL實(shí)例時(shí)，如果不需要默認(rèn)的MySQL數(shù)據(jù)庫，我們就需要手動(dòng)創(chuàng)建一個(gè)user表來存儲(chǔ)用戶信息。