Grant a user s 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  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.  

Removing a user s permissions  

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: 

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

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

21