Sign Up / Log In
Need help?
08456 171 171
Online Support Web Hosting

How to manage MySQL user privileges

Only users granted permission to read, create, edit, delete, or perform any actions regarding data within your MySQL databases can do so. You can set database user privileges within the Hosting Manager.

To set and/or manage database user privileges, follow the steps below:

  1. Click Sign Up / Log In at the top of this page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Databases or the [ v ] arrow symbol on the right side.
  5. Next, click the MySQL Databases button, which is next to phpMyAdmin icon.
  6. On the MySQL Databases main page, under Current Databases, find the database you want to grant or deny access to, and then find the user that you want to modify the privileges of. Click the selected privileged user name.
  7. Next page, make the appropriate permission changes by checking, or unchecking, the boxes that correspond to the privileges that you want to grant, or disallow, the user. You can also choose to check All Privileges to give the user permission to do everything on the list.
  8. Click Make Changes.
    If the modifications are saved, you will get the following message:
  9. √ Updated the privileges for user “user” on the database “database_name”.
  10. Click Go Back to go back to the MySQL Databases main page.

Note: When modifying privileges, make sure you select the right database and privileged user name. Users may have access to more than one database.

Congratulations, you now know how to modify or update MySQL database user privileges.

Was this helpful? Yes No 67% of people found this helpful.
Need Help? Chat Now