cPanel KnowledgeBase and Troubleshooting, cPanel Server Fixes and Tutorials

InnoDB force Recovery, There are many reasons available to get database corrupted. Make sure that you maintain a good backup schedule by running a cpanel backup in case of serious corruption or data loss issue or refer with Mysql knowledgebase. InnoDB corruption can cause all of the databases running on that server to be inaccessible. […]

MySQL Performance Tuning Shell Script, This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…” then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above. In your huge traffic cPanel server you can use the following MySQL performance tuning script to optimize […]

Sql.safe mode Errors If you have any mysql connection errors and received error with cpanel user name authentication errors. If sql.safe_mode is enabled, mysql_connect() and mysql_pconnect() ignore any arguments passed to them. Instead, PHP attempts to connect using the following details: host: local host user: the user PHP runs as password: an empty string (“”) […]

MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, Monty Program works to hire the best and brightest developers in the industry, work closely and cooperatively with the larger community of users and developers in the true spirit of Free and open […]

You can use the following php script which is used to test mysql database connection on your cpanel server. <?php $link = mysql_connect(‘db_host’, ‘db_username’, ‘db_password’); if (!$link) { die(‘Could not connect the database: ‘ . mysql_error()); } echo ‘Database Connected successfully’; mysql_close($link); ?> db_host : Mostly used ‘localhost’ when you connect on the same server. […]