A user will no longer be able to access a particular database when you have removed their permissions to that database.
To remove a user's permissions:
Click on the Add/Remove MySQL Databases link in the Domain Menu area.
Click on the button next to the specific user underneath the name of the database in the Existing MySQL databases area. Click on the MySQL databases link to return to the MySQL databases window to confirm that permissions have been removed.