CREATE USER

Purpose

You can use this statement to create an OceanBase Database user. After you create a user, you can use it to connect to OceanBase Database.

Syntax

CREATE USER [IF NOT EXISTS] user_specification_list
    [REQUIRE {NONE | SSL | X509 | tls_option}];

user_specification_list:
    user_specification [, user_specification ...]

user_specification:
    user IDENTIFIED BY  'authstring'
  | user IDENTIFIED BY PASSWORD 'hashstring'

tls_option:
 | CIPHER 'cipher'
 | ISSUER 'issuer'
 | SUBJECT 'subject'

Parameters

Examples

1. Create users named sqluser01 and sqluser02, and specify passwords in plaintext.

   obclient> CREATE USER 'sqluser01' IDENTIFIED BY '******', 'sqluser02' IDENTIFIED BY '******';
   

2. Create a user named sqluser03 and specify a password in ciphertext.

   // Query the password in ciphertext.
   obclient> SELECT PASSWORD FROM mysql.user;
   ```sql
   obclient> CREATE USER 'sqluser03' IDENTIFIED BY PASSWORD '******************';
   
   
   

3. Query the users that you created.

   obclient> SELECT user FROM mysql.user;
   +-----------+
   | user      |
   +-----------+
   | root      |
   | admin     |
   | sqluser01 |
   | sqluser02 |
   | sqluser03 |
   +-----------+
   5 rows in set