Create MySQL user

First create user:

 CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY 'clear text password>';
 or
 CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY PASSWORD '<encrypted password>';

Grant some rights to the user (here all as * is used):

GRANT * ON <database name>.* TO '<username>'@'<host to connect from>';

Put privileges into action:

FLUSH PRIVILEGES;

Check MySQL documentation for more details.