|
|
|
|
|
|
Once you have created a user to use a database you need to grant that user permission to use the database. To grant user permissions to a mySQL database: Click on the MySQL Databases link in the Advanced Menu area. 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 button. The user now has permission to use that database and sample connection strings are shown in the mySQL window.
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 link in the Advanced Menu area. Click on the button next to the specific user underneath the name of the database in the Databases area. |