Changing permissions for a database user in hPanel
Changing the permissions of the database user might be useful if you want to have custom preferences for some databases, for example, to make a database with read-only permissions.
-
To change your database’s permissions, go to Hosting → Manage, search for MySQL Databases on the sidebar and click on it:
- In the section List of Current MySQL Databases And Users, click on ⋮ button in front of the desired database and choose Change Permissions:
- By default, MySQL user has all the permissions granted. You can revoke permissions by removing the checkmark next to the specific permission:
Once everything is ready, click on Update to apply the changes
