WEB HOSTING SUPPORT NETWORK
     
 

Modifying the privileges of a MySQL user for a database

If a MySQL user does not have any privileges over a database, you should associate it with that database. Detailed instructions on the process are available in our Associating a MySQL user with a database article.

Note: The MySQL 5 and MySQL 8 servers are separate and do not share databases or users, so you can grant privileges to MySQL 5 databases only to MySQL 5 users and privileges to MySQL 8 databases only to MySQL 8 users. If you have two users for MySQL 5 and MySQL 8 with the same name, and modify the privileges for one of these users, the privileges for the other user will not be changed.

To modify the privileges of a MySQL user for database, you need to follow these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the Privileges tab.
  4. Select the MySQL version of your database from the MySQL version drop-down menu.
  5. Click on the Edit (button_edit_hover.gif) button next to the database and MySQL user whose permissions you would like to change.
  6. From the Privileges section, select the new privileges that you wish to grant to the MySQL user. If you remove all privileges, the association between the MySQL user and the database will be removed.
  7. Click on the Associate button.

Note: By default, your master MySQL user always has full privileges over your databases. Due to security concerns, we recommend that you create and use a separate MySQL user for each software application installed on your account.

If you would like to remove all privileges a MySQL user has over a database, follow these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the Privileges tab.
  4. Select the MySQL version of your database from the MySQL version drop-down menu.
  5. Click on the Remove (cancel_a.png) button next to the database and MySQL user whose permissions you would like to remove.