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:
-
Click on the MySQL databases button on the home page.
-
Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
-
Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window.
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:
-
Click on the MySQL databases button on the home page.
-
Click on the Delete button next to the specific user underneath the name of the database in the Databases area.
