This tutorial will show you how to grant user permissions to a MySQL database

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:

1. Click on the Add/Remove MySQL Databases link in the Domain Control area.

2. Choose the specific user from the Username drop-down list in the Grant all permissions on a MySQL database to a MySQL user area.

3. Choose the specific database to grant permissions to from the MySQL database drop-down list.

4. 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.