How to create MySQL user and database

CREATE DATABASE erlms_site1_db CHARACTER SET utf8 COLLATE utf8_general_ci
GRANT ALL privileges on erlms_site1_db.* to ‘benin_mysqladmin’@’localhost’ with grant option;
FLUSH PRIVILEGES;