write mysql command to create database and user?

CREATE DATABASE lportaldb CHARACTER SET utf8;

create user admin identified by 'admin';


GRANT ALL PRIVILEGES ON lportaldb.* to admin@localhost IDENTIFIED by 'admin';