Creating users
CREATE USER username IDENTIFIED BY password;
Only an administrator has the privilege to execute this statement. The following example creates a new user named CALVIN with the password HOBBES.
CREATE USER CALVIN IDENTIFIED BY HOBBES;
See also