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]] ...
To create an account by executing the
CREATE USER statement, you must have the
Create an account named account2 and set the password to Account2.
CREATE USER if not exists 'account2' IDENTIFIED BY 'Account2';