Update MySQL database for centos web panel
Here are simple steps to update MySQL database server 5.1 to MySQL database server 5.6 for Centos web panel: Login to your server…
Category: MySQL Tips and Tricks
The mod_security plugin could not connect to the database. Please verify that MySQL is running. Error: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) – Solution
If you’re getting following error while accessing mod_sec from WHM, here is the quick solution for this. The Mod Security plugin could not…
Cron job for backing up MYSQL database from SSH
Backing up MYSQL databases became very necessary especially if you own a shopping cart or e commerce website. Hackers are always trying to…
Horde database error while taking backup in cPanel/WHM – Quick Fix
If you are having the issue in horde database while taking backup from cPanel/WHM or while transferring an account from one server to another,…
MySQL instant commands – Repair, Analyze, Optimize
Following commands are useful for mysql optimization: To repair all databases: $mysqlcheck –all-databases -r To analyze all databases: $mysqlcheck –all-databases -a To optimize…
Best mysql configurations
In this post i will describe what are the best configurations for mysql server, you can edit your my.cnf file to reflect the…