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

Web Hosting

Cannot connect MySQL with PHP scripts

Posted on

If you cannot seem to connect to mysql with a PHP script then it might happen due to the PHP scripts under a domain are not able to connect the MySQL server. You might have mentioned the connection strings correctly but still not able to connect mysql through scripts. To sort this error you can […]