Creating database level user in MYSQL
you can create user on database level by using the following command:

grant all privileges on MyDB.* to MyUser@'host' identified by 'password';


Note: you can change all privileges to any privileges you want, but you need to make sure its enough for the user to log in and get needed data.