How can I 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. 1- Click on the MySQL databases button on the Cpanel home page. 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 Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window.

Related Articles

How can I create a MySQL database?

1- Click on the MySQL databases button on the Cpanel home page. 2- Enter the name of the database in the Db field. 3- Click on the Add Db button. The database will be added to the...

How can I Remove a database?

Removing a database will delete that database from its online location. Be sure that you have saved a copy of the database if you want to keep any of the information in the database. Removing a...

How can I Create a MySQL user?

You need to create a MySQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the specific...

How can I Remove a user?

Removing a user deletes that user - it removes all database permissions that the user has and does not allow that user access to any MySQL databases. 1- Click on the MySQL databases button on...

How can I Remove 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. 1- Click on the MySQL databases button on the home page. 2- Click on...