Apache vs Nginx

Web server is essential for all server to serve the content over the internet. There are a lot of web servers available in the market. The two Major web servers are Apache and Nginx. A lot of people are confusing themselves about choosing the one among both of them. In this article, I am going […]

Continue reading


MySQL Workbench Tutorial

MySQL is an open source relational database. MySQL is cross platform which means it runs on a number of different platforms such as Windows, Linux, and Mac OS etc. Why use MySQL? There are a number of relational database management systems on the market. Examples of relational databases include Microsoft SQL Server, Microsoft Access, Oracle, DB2 etc. One […]

Continue reading


MySQL on Linux Tutorial

The MySQL Database Installation and configuration: Red Hat / Fedora Core RPM Packages: RHEL 6/CentOS/AWS MySQL 5.5 example: mysql-version.rpm (Required. Includes client) mysql-server-version.rpm (Required) mysql-config-version.rpm (Required config file: /etc/my.cnf) mysql-devel-version.rpm (Optional: C include files and libraries for developers) php-mysql-version.rpm (Optional: For accessing MySQL database from php) Install: rpm -ivh mysql-version.rpm mysql-server-version.rpm mysql-config-version.rpm Check if installed: rpm -q mysql […]

Continue reading


How To Configure the Apache Web Server

What is Apache? Apache is the most popular web server on the internet. It is used to serve more than half of all active websites. Although there are many viable web servers that will serve your content, it is helpful to understand how Apache works because of its ubiquity. In this article, we will examine […]

Continue reading


How To Secure Apache

Introduction Let’s Encrypt is a Certificate Authority (CA) that provides an easy way to obtain and install free TLS/SSL certificates, thereby enabling encrypted HTTPS on web servers. It simplifies the process by providing a software client, Certbot, that attempts to automate most (if not all) of the required steps. Currently, the entire process of obtaining and […]

Continue reading


phpMyAdmin Installation Tutorial

All hosting accounts on the SiteGround servers come with pre-installed phpMyAdmin software. The application can be opened from cPanel -> phpMyAdmin tool. However, you may need to install phpMyAdmin manually. The easiest way is to install the application from the Softaculous tool in cPanel. Alternatively, you can perform the installation manually. Manual PhpMyAdmin Installation To install phpMyAdmin manually, […]

Continue reading