Creation should include the following syntax:

CREATE USER username IDENTIFIED BY password;