SQL

How to Customize the version of MySQL database in cPanel

Posted on
How to Customize the version of MySQL database in cPanel

In this article, you will find the procedure of Customizing the version of the MySQL database, when installing cPanel for the first time. It is possible to preconfigure a cPanel installation so that your desired version of MySQL is installed from the start. Let’s follow the Procedure to Customize the version of the MySQL database […]

SQL

What is the procedure of restoring MySQL user grants.

Posted on
MySQL user grants

In this article, you will find the procedure of restoring MySQL grants. The /usr/local/cpanel/bin/restoregrants script restores database users grants from the data in the /var/cpanel/databases/grants_* files. One can restore the grants using the following command: /usr/local/cpanel/bin/restoregrants [–cpuser=cpuser] [–db=mysql|pg] [–dbuser=dbuser|–all] The above-discussed method is the basic and easiest way for restoring your MySQL user grants using […]