MySQL :: Create user

To create user

mysql> create user <username> identified by '<password>'

Then grant privileges

mysql> grant select, insert, update, delete, create, drop on <database_name>.* to '<username>'@'<mysql_host>';

or 

mysql> grant all privileges on <database_name>.* to '<username>'@'<mysql_host>';