In this tutorial, we’ll explain how you can map MySQL databases and users to cPanel users. MySQL doesn’t have any kind of concept of database ownership; for this reason, cPanel…
Category: SQL
How to Customize the version of MySQL database in cPanel
July 16, 2021 / SQLIn 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…
What is the procedure of restoring MySQL user grants.
April 23, 2021 / SQLIn 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…
When MySQL fails, it shows Errcode: 30
April 16, 2021 / SQLIn 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…
If you want to assign a TCP/IP port number to the SQL Server Database Engine. You must follow the steps given below- Open SQL Server Management Studio and login to…
Disaster recovery! Makes you restless, right? What if it turns into reality with your business? Made your blank. No this isn’t said to scare you. In fact, this article is…
How to Migrate the Database from MS SQL to MySQL?
April 13, 2015 / SQLThere are several companies that prefer migrating their database from MS SQL to MySQL. It becomes essential for enterprises to migrate to MySQL when there are few MS SQL server…
Cannot Connect MySQL with PHP Scripts
June 6, 2013 / SQLIf 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 to…