Blog

09 Apr
2020
ColorHosting BaseZap

How to Install Nginx, MySQL, PHP (LEMP) Stack on CentOS

This guide will help you install Nginx, MySQL, PHP (LEMP) Stack on CentOS machine i.e. Server. LEMP is a software stack comprised of Nginx as Web Server and MySQL as Database server along with PHP as the dynamic content processor for websites. LEMP term is actually an acronym that represents the Linux, ENginx (replaces ‘A’ […]

04 Apr
2020
ColorHosting BaseZap

MySQL database operation via terminal for MAMP [mac] users

We will be demonstrating on how to use MySQL from terminal of MAC OS  which has MAMP installed on it. Some common functionalities will include : Selecting a database and running related commands Importing database Exporting database First step would be to run MAMP and make sure MYSQL server is ON Open terminal and run […]

26 Jan
2020
ColorHosting zapbase

Change or reset password of MySQL user from terminal

If you have root access to your server and wish to change/ reset password of a MySQL user, then you can do via following method via terminal access to the server : Login into the server via root users. Type mysql (press enter) to enter into myql command prompt Here we have got MariaDB, since […]

01 Sep
2018
ColorHosting BaseZap

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 BaseZap

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 BaseZap

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 BaseZap

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 BaseZap

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