It is very easy to create a new user in mysql and give access to database. By using GRANT, you can assign what privileges to any user not only new but also existing users. Just make sure you are using the right username and hostname. Recently, I am working on setting up master and slave replication. But I don't want all my master tables and databases backup on my slave database. Therefore, I listed some important grant statements here that you can use. Also, I provided some hints below as well.