OceanBase CREATE USER

描述

該語句用于創(chuàng)建新的 OceanBase 用戶。創(chuàng)建新用戶后，可以使用該用戶連接 OceanBase。

說明 
必須擁有全局的 CREATE USER 權(quán)限，才可以使用 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  ‘a(chǎn)uthstring’
| user IDENTIFIED BY PASSWORD ‘hashstring’

參數(shù)解釋

示例

1. 執(zhí)行以下命令創(chuàng)建名為 sqluser01 和 sqluser02 的用戶，密碼均為 123456。

CREATE USER 'sqluser01' IDENTIFIED BY '123456', 'sqluser02' IDENTIFIED BY '123456';

1. 執(zhí)行以下命令查看創(chuàng)建的用戶。

SELECT user FROM mysql.user;

執(zhí)行結(jié)果如下所示。

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)