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 […]

SQL

When MySQL fails, it shows Errcode: 30

Posted on

In this tutorial, we’ll explain to you the problems stemming when MySQL fails to begin and shows Errcode:30 What is MySQL? MySQL is basically a Structure query language. MySQL lets you access and handle databases. It is a computer language for storing and retrieving data stored in relational databases. Why MySQL fails to begin and […]