Ubuntu

How To Install and Configure Squid 3 on Ubuntu

Install Squid on CentOS 7

In this tutorial we will show you how to install and configuration of Squid on your Ubuntu server. 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 organisation and internet providers to reduce bandwidth and to increase response time. This article assumes you have at least basic knowledge of linux, kno...

How To Increase PHP Memory Limit

php-logo

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 on how you can increase the php memory limit. Check PHP Memory Limit You can check by creating a file called info.php in /var/www/html/ with the following content: [cray...

How To Reset Root Password MySQL Server

Install MySQL Server on Ubuntu 16.04

By default, MySQL server will be installed with root account and 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 these instructions and we assume that you already have a small amount of knowledge on MySQL...

How To Enable Slow Query Log for MySQL

Install MySQL Server on Ubuntu 16.04

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 long time to execute and are therefore candidates for optimization. We assume that you alread...

How To Backup and Restore MySQL Database Using Command Line

Install MySQL Server on Ubuntu 16.04

This tutorial guide will show you two easy ways to backup and restore the data in your MySQL database using mysqldump. You can also use this process to move your data to a new web server. We assume that you already have MySQL installed on Linux system with administrative privileges and we assume that you already have a small amount of knowledge on MySQL. The parameters of the said command as fo...