You can execute the CREATE USER statement to create an account. 

CREATE USER
    [if not exists] user [auth_option] [, [if not exists] user [auth_option]] ...

Precautions

To create an account by executing the CREATE USER statement, you must have the CREATE_USER permission.

Example

Create an account named account2 and set the password to Account2.

CREATE USER if not exists 'account2' IDENTIFIED BY 'Account2';