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

FAQs

How to install MySQL in Windows Operating System?

Posted on

The following are the steps to install Mysql in Windows – The Zip file – MySQL-shareware-3_22_34-win.zip Also, check for the latest versions on the internet a) A temporary directory should be createdb) Unzip the file to the directoryc) After the unzip process, search for “setup.exe”d) Make sure you close all programse) Search for Setup File […]