Centos

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...

How To Completely Removing MySQL Server in CentOS

remove-mysql-list

In this tutorial we will show you how to completely removing of 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 compatib...

How To Replacing OpenSSH With Dropbear on CentOS

dropbear-conf-port

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 a MIT-style license. Dropbear is particularly useful for "embedded"-type Linux (or other Unix) systems, such as wireless routers. This article assumes you have at least basic knowledge of linux, know how to u...

How To Install Suhosin PHP 5 Protection Security Patch on CentOS

php-logo

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, Suhosin patch is an advanced protection system for PHP installations. It was designed protect your servers against a number of well known problems in PHP applications and on the other hand against potential unknown vulnerabilities within these applications or th...

How To Install MySQL Database Server on CentOS

Install MySQL Server on Ubuntu 16.04

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 all major operating systems. MySQL can be used for a variety of applications, but is ...

How To Install IonCube Loader on CentOS

IonCube-Loader

For those of you who didn’t know, IonCube Loaders is basically an encryption/decryption utility for PHP applications which also assists in speeding up the pages that are served. It is often required for a lot of PHP-based applications. This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The inst...

How To Install PHP 5.5 on CentOS

php-5.5-centOS

This tutorial will show you how to install PHP 5.5 on CentOS. For those of you who didn’t know, PHP (PHP: Hypertext Preprocessor) is a server-side scripting language designed for web development but also used as a general-purpose programming language. PHP code is interpreted by a web server with a PHP processor module, which generates the resulting web page: PHP commands can be embedded direct...

How To Configuration Iptables Firewall on CentOS

iptables-centos

For those of you who didn’t know, iptables is a user space application program that allows a system administrator to configure the tables provided by the Linux kernel firewall (implemented as different Netfilter modules) and the chains and rules it stores. Different kernel modules and programs are currently used for different protocols; iptables applies to IPv4, ip6tables to IPv6, arptables to...