How to add a user for my database?

You could add a user using GRANT command. Note that user should have rights to select, insert, update, delete. A MySQL Grant statement for this user would look like this:

 
GRANT 
  select, insert, update, create, alter, delete, drop 
ON 
 database.* 
TO 
 user@localhost 
IDENTIFIED BY 
 'password';