All Collections
MySQL Databases
Database Management
How to Change Permissions for a Database User
How to Change Permissions for a Database User

Changing permissions for a database user in hPanel

Updated over a week ago

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 Websites Manage, search for Databases Management 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 😊

Additional resources:

Did this answer your question?