MySQL Adding user & privileges

grant all privileges on MYDBNAME.* to user@localhost identified by 'somepass' with grant option;
 
flush privileges;

Read More