MySQL Database Permisions

For WHMCS to run properly and maintain security, we recomend the following data base user permision settings;

During installation and updates of WHMCS

You should allow the defined user all priviledges during this process.


During normal operation we recomend disabaling all permisions except for;

DELETE
SELECT
INSERT
UPDATE

You can view the users permisions by going loging into our portal system and selecting your hosted account.
When you select the account you will be able to login to cPanel via a secured API transaction.

Inside of cPanel please select;

MySQL® Databases application

Onces inside navigate down to the section titled

Current Databases

Depending on your account, you might have multiple databases and users who have acces to it.
Please open up a support ticket if you are not sure. And we can guide you the rest of the way.

find the correct database and select the user in the Privileged Users heading.
You are now at the edit permisions screen for this user.

Repeat the process for every WHMCS installation.

During incremental updates please remember to following the above steps; and re-enable all priviledges as to not interrupt the update process.

Was this helpful?

 Print this Article

Also Read

System Domains being registered in WHMCS

This is a small guide on an issue we found with WHMCS v 7.1.We noticed malicious users registering subdomains on domains we own. like...

OpenSRS Pro Module

PHP Warning:  Parameter 2 to override_tpl_output_filter() expected to be a reference, value given in...