Blog

01 Sep
2018
ColorHosting Deepak Sharma

Guide to Raise ulimit open files and MySQL open_files_limit

The operating system provides ways of limiting the amount of resource that can be used. Limits are set for each user but are applied separately to each process that is running for that user. Administering Unix servers can be a challenge, especially when the systems you manage are heavily used and performance problems reduce availability. Linux itself […]

23 Aug
2018
ColorHosting Deepak Sharma

Enable and Use Remote MySQL Connections in cPanel

Wondering if you can connect your website’s Database on your Local Computer? Yes, absolutely you can. There are a few programs you can use to connect remotely to your database. You can utilize HTML editors like Adobe Dreamweaver for a fee, or there are free Open Source programs you can use like MySQL Workbench or Heidi […]

08 Aug
2018
ColorHosting Deepak Sharma

Guide to fix MySQL hangup problem in WHM/cPanel Server

Facing issues like the crashing of MySQL server and unable to restart due to connection timed out when restarting? This problem can occur when your website’s database is large and have high traffic. Due to this when you or WHM wants to restart the MySQL, it sticks there and throws the timeout error. Above stated problems […]

27 Jun
2018
ColorHosting Deepak Sharma

InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

Fix mysqld process using the same InnoDB data or log files Problem Own a MySQL server and facing Database connection failures and crashes? The reason could be duplicate SQL queries and Processes running on your server. There is an easy fix for this problem. MySQL Logs throws an error as below InnoDB: Check that you do not already […]

25 May
2018
ColorHosting BaseZap

[Solved] Remote MYSQL connection not working in cPanel account

Remote MYSQL database not connecting from a cPanel based interface even after whitelisting your remote IP from “remote MYSQL” ? It must be due to faulty MYSQL CNF file (my.cnf). Here are the quick steps to fix this : Open my.cnf file in terminal using following command : sudo nano /etc/my.cnf Locate the bind address  […]

14 May
2018
ColorHosting Deepak Sharma

How To Install Linux, Apache, MySQL, PHP (LAMP) stack On CentOS 6

What is LAMP? LAMP stands for a cluster of open source software used to run servers. It is an acronym for Linux, Apache, MySQL, and PHP. Since the server already runs CentOS, the Linux part is taken care of. Below are the steps of installation of the rest.   Set UP You need to have […]

10 Apr
2018
ColorHosting BaseZap

Import / export mysql or maria database using linux terminal

Following tutorial helps in exporting or importing MySQL / MariaDB database using terminal commands. It is very useful when the database size is pretty big and the software like PHPMyAdmin , MySQL workbench might give you timeout issue or take abnormally very high time. Using the following method is a direct interaction with the MySQL server and […]

26 Feb
2018
ColorHosting Deepak Sharma

Guide for changing TimeZone of WHM/cPanel Server

Hello, Today we will show you the Guide for changing TimeZone of Server using cPanel / WHM. The steps are very simple to follow, we will include screenshots as well for demonstration. Requirements WHM / cPanel installed on Server with its credentials. Root SSH Access to MySQL Server Procedure Change TimeZone in WHM This will […]

17 Feb
2018
ColorHosting basezap

Make MySQL Faster by Killing Sleep Connections Automatically

Here’s a Bash script to kill sleeping MySQL connections automatically and almost immediately to decrease MySQL CPU Usage and make MySQL Faster. This tutorial works only if you have a server with root access, and you’re logged in as root. This script uses about 0.25% on a normal VPS with 1vCPU of the CPU with […]