In this tutorial, we will show you how to install and configure Squid 3 on CentOS. For those of you who didn’t know, Squid is a caching proxy for the Web supporting HTTP, HTTPS, FTP, and more. Squid proxy is used by various organizations and internet providers to reduce bandwidth and to increase response time. This article assumes you have at least basic knowledge of Linux, know how to use th...
In this tutorial, we will show you how to increase the PHP memory limit on a Linux server. If you have seen an error like ”Fatal Error: PHP Allowed Memory Size Exhausted” in webserver logs or your browser, this means that PHP has exhausted the maximum memory limit. This tutorial will show two different ways how you can increase the PHP memory limit. This article assumes you have at least ba...
In this tutorial, we will show you how to install Varnish Cache on CentOS. For those of you who didn’t know, Varnish is an open-source reverse HTTP proxy, an HTTP accelerator, and a useful tool for speeding up an Apache server. The varnish is also known as front-end web caching software that you put in front of an Apache webserver to speed it up. It makes your website really fast and accelerat...
In this tutorial, we will show you how to reset the root password MySQL server. By default, the MySQL server will be installed with the root account and the password is blank. Have you ever forgotten the root password on one of your MySQL servers? If you have set the password for root and forget it, then you will need to reset the root password for MySQL. To reset your MySQL password just follow...
In this tutorial, we will show you how to enable a slow query log for MySQL on Linux systems. MySQL has built-in functionality that allows you to log SQL queries to a file, You can enable the full SQL queries logs to a file or only slow running queries log. It is easy for us to troubleshoot/ debug the SQL statement if SQL queries log enable, The slow query log is used to find queries that take a...
In this tutorial, we will show you how to backup and restore the MySQL database using Command-Line. For those of you who didn’t know, MySQL is an open-source database developed by Oracle whereas MariaDB is a fork of it that works similarly and uses the same command line as MySQL. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, ...
In this tutorial, we will show you how to complete removing MySQL on your CentOS server. For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is compatible w...
In this tutorial, we will show you how to replace OpenSSH with Dropbear on CentOS. For those of you who didn’t know, Dropbear is a relatively small SSH server and client. It runs on a variety of POSIX-based platforms. Dropbear is open-source software, distributed under an MIT-style license. Dropbear is particularly useful for "embedded"-type Linux (or other Unix) systems, such as wireless rout...
In this tutorial, we will show you how to install Suhosin PHP 5 protection security patch on CentOS. For those of you who didn’t know, the Suhosin patch is an advanced protection system for PHP installations. It was designed to protect your servers against a number of well-known problems in PHP applications and on the other hand against potential unknown vulnerabilities within these applicatio...
In this tutorial, we will show you how to install MySQL Database Server on CentOS. For those of you who didn’t know, MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is compatible with al...