Creating database level user in MYSQL Our MySql production server has two different databases in it.
For reports I want the user to only be able to see reports database and not main database. I created A user  'username@%' for the reports plugin in the server and gave it vie,select,execute privileges on reports db.
 Now when the developer connects to database using those credentials from reports plugin, they report that they are able to see the other database and all it's tables as well.
What should I do to prevent them from seeing the other database. In short: when developer logs in from reporting plugin, they should only see the report database.
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.