CREATE USER · k8s原理与实践

[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) ~~~