Once you have created a user to use a database you need to grant that user permission to use the database. If you have not yet created a user, refer to Creating a MySQL user for more information.
To grant user permissions to a MySQL database:
Click on the Add/Remove MySQL Databases link in the Domain Menu area.
Choose the specific user from the Username drop-down list in the Grant all permissions on a MySQL database to a MySQL user area.
Choose the specific database to grant permissions to from the MySQL database drop-down list.
Click on the Grant permissions button. Click on the MySQL databases link to return to the MySQL databases window to confirm that permissions have been granted - you will see Connection Strings listed underneath users in the Existing MySQL databases area.