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