[TOC] # 创建用户 ## 通过 SQL 语句创建 MySQL 模式的用户 * MySQL 模式 MySQL 模式的用户管理语法树如下所示： ~~~ 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 ~~~ MySQL 模式下，创建名为`sqluser01`和`sqluser02`的用户，且密码均为`123456`，示例如下： ~~~ obclient> CREATE USER 'sqluser01' IDENTIFIED BY '123456', 'sqluser02' IDENTIFIED BY '123456'; ~~~ 更多 MySQL 模式下`CREATE USER`语句的信息，请参见[CREATE USER](https://open.oceanbase.com/docs/community/oceanbase-database/V3.1.0/create-user-1)。