[TOC] # CREATE USER ## 描述 該語句用于創建新的 OceanBase 用戶。創建新用戶后，可以使用該用戶連接 OceanBase。 **說明** 必須擁有全局的CREATE USER權限，才可以使用CREATE USER命令。 ## 格式 ~~~ create_user_stmt: CREATE USER [IF NOT EXISTS] user_name [IDENTIFIED BY 'password']; alter_user_stmt: ALTER USER user_name ACCOUNT {LOCK | UNLOCK}; | ALTER USER user_name IDENTIFIED BY 'password'; | SET PASSWORD [FOR user_name] = PASSWORD('password'); | RENAME USER rename_user_action_list; drop_user_stmt: DROP USER user_name_list; rename_user_action_list: rename_user_action [, rename_user_action ...] rename_user_action: user_name TO user_name user_name_list: user_name [, user_name ...] password: STR_VALUE CREATE USER [IF NOT EXISTS] user_specification_list; user_specification_list: user_specification [, user_specification ...] user_specification: user IDENTIFIED BY ‘authstring’ | user IDENTIFIED BY PASSWORD ‘hashstring’ ~~~ ## 參數解釋 <table data-tag="table" id="table-1gk-h8k-2hx" class="table"><colgroup width="334" span="1" data-tag="col" id="col-mga-2kv-7rs" colwidth="1*" colnum="1" colname="col1" style="width:50%" class="col"></colgroup><colgroup width="360" span="1" data-tag="col" id="col-wyl-6az-ys2" colwidth="1*" colnum="2" colname="col2" style="width:50%" class="col"></colgroup><thead id="thead-66z-ld0-17a" class="thead"><tr id="tr-qvy-mcf-tzj"><th id="td-see-qbc-rct"><p id="p-83k-n6k-dv3"><b>參數</b></p></th><th id="td-p5l-dlq-z28"><p id="p-na4-qg5-ak6"><b>描述</b></p></th></tr></thead><tbody data-tag="tbody" id="tbody-yk3-ncs-zbh" class="tbody"><tr data-tag="tr" id="tr-bcu-uh5-59q" class="tr"><td data-tag="td" id="td-xfe-p36-b3b" class="td"><p id="p-k2i-w65-lku">user_name</p></td><td data-tag="td" id="td-mu8-dyl-lnc" class="td"><p data-tag="p" id="p-r1d-nol-nh3" class="p">用戶名，新建用戶后，“mysql.user”表會新增一行該用戶的表項。如果同名用戶已經存在，則報錯。</p></td></tr><tr data-tag="tr" id="tr-g0e-3ww-p4k" class="tr"><td data-tag="td" id="td-f0j-vy3-eij" class="td"><p data-tag="p" id="p-j5v-xat-qx2" class="p">IDENTIFIED BY</p></td><td data-tag="td" id="td-u7u-tgp-m2h" class="td"><p data-tag="p" id="p-pk0-yuw-5se" class="p">使用自選的 IDENTIFIED BY 子句，可以為賬戶給定一個密碼。</p></td></tr><tr data-tag="tr" id="tr-2oe-8of-wkz" class="tr"><td data-tag="td" id="td-jt6-xok-xt9" class="td"><p data-tag="p" id="p-f65-296-lvi" class="p">user_name [, user_name ...]</p></td><td data-tag="td" id="td-0tw-5t9-rfj" class="td"><p data-tag="p" id="p-xln-vdg-7bt" class="p">同時創建多個用戶時，用“,”隔開。</p></td></tr><tr data-tag="tr" id="tr-h58-s9g-8mu" class="tr"><td data-tag="td" id="td-t5g-nnm-2lx" class="td"><p data-tag="p" id="p-skr-3u6-jij" class="p">user IDENTIFIED BY ‘authstring’</p></td><td data-tag="td" id="td-egg-eah-vhi" class="td"><p data-tag="p" id="p-7gm-r0f-fkz" class="p">此處密碼為明文，存入“mysql.user”表后，服務器端會變為密文存儲下來。</p></td></tr><tr data-tag="tr" id="tr-o5a-ea9-gck" class="tr"><td data-tag="td" id="td-94n-2y7-y9t" class="td"><p id="p-kex-ej8-7pt">user IDENTIFIED BY PASSWORD ‘hashstring’</p></td><td data-tag="td" id="td-jip-hc3-6mk" class="td"><p id="p-d6y-qdh-3zn">此處密碼為密文。</p></td></tr></tbody></table> ## 示例 1. 執行以下命令創建名為 sqluser01 和 sqluser02 的用戶，密碼均為 123456。 ~~~ CREATE USER 'sqluser01' IDENTIFIED BY '123456', 'sqluser02' IDENTIFIED BY '123456'; ~~~ 2. 執行以下命令查看創建的用戶。 ~~~ SELECT user FROM mysql.user; ~~~ 執行結果如下所示。 ~~~ mysql> CREATE USER 'sqluser01' IDENTIFIED BY '123456', 'sqluser02' IDENTIFIED BY '123456'; Query OK, 0 rows affected (0.12 sec) mysql> select user from mysql.user; +-----------+ | user | +-----------+ | root | | admin | | sqluser01 | | sqluser02 | +-----------+ 4 rows in set (0.00 sec) ~~~