Grant a user's permissions to a mySQL database

Back to Main Menu

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 SQL Database link in the Site Management Tools area.

2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.

3. Click on the button. The user now has permission to use that database and sample connection strings are shown in the mySQL window.

Topics:

Creating a database
Removing a database
Creating a mySQL user
Removing a mySQL user
Removing a user's permissions to a mySQL database
Managing mySQL databases