Thank you for your question. In a normal environment you should be able to set the permissions in that manner. However, when you are using a cPanel, privileges must be set in cPnael. As it is just the way cpanel operates.
To change a database user's permissions in cPanel, click the MySQL Databases button under Databases, then under Current Databases click the username that you want to modify the privileges for, and you will be able to choose the permissions you want to grant the user.
Here is a link to a full article titled "Changing a Database User's Privileges"
If you have any further questions, feel free to post them below, or contact live Tech Support.
They are available 24/7 via:
Phone: 877-595-4482 x2
Chat (there is a link on the top right).
|Email:||support@WebHostingHub.com||Ticket:||Submit a Support Ticket|
|Chat:||Click To Chat Now|