Example of Create User Mysql Statement:
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';
CREATE USER michael IDENTIFIED BY PASSWORD 'mypassword123';
Example of Mysql CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...