×


Blog


Install phpMyAdmin with Apache on Debian 9 - Step by Step Process ?

This article covers step by step process to Install and Configure phpMyAdmin with Apache on Debian 9 system. The phpMyAdmin utility is a graphical database management tool. By installing phpMyAdmin, you no longer need to use a default command-line interface to manage your databases.


To install wget:

1. Access your terminal window, and update your software package lists using the following command:

$ sudo apt update

2. The wget utility allows you to download files directly from the terminal window. Enter the following command to install the wget tool:

$ sudo apt install wget -y


To install Apache on Debian:

1. Open a terminal window, and install Apache by entering the following command:

$ sudo apt install apache2 -y

2. Enter the following command to make sure the Apache service is running:

$ systemctl status apache2

In the output, you should see a green status that says active (running).


To Install PHP on Debian 10:

1. Install core PHP packages and Apache and MySQL plugins with the following command:

$ sudo apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y

2. Once the installation process is complete, verify that PHP has been installed:

$ php --version

The system displays the current version of PHP, along with the date of the release.

Read More

Install MariaDB on Ubuntu 18.04 - Step by Step Process ?

This article covers how to install MariaDB on Ubuntu 18.04 server. Also, you will learn how to secure and connect to MariaDB server. MariaDB is an open-source relational database management system, commonly used as an alternative for MySQL as the database portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. Basically, It is intended to be a drop-in replacement for MySQL.


How to Install MariaDB ?

1. To install it, update the package index on your server with apt:

$ sudo apt update

2, Then install the package:

$ sudo apt install mariadb-server

Read More

Secure Apache with Let's Encrypt on CentOS 7 - Step by Step Process ?

This article covers how to secure Apache with Let's Encrypt SSL on CentOS 7 using Certbot client. Also, you will learn how to set up a cronjob for automatic certificate renewal. Basically, A security certificate is critical for securing traffic sent from web browsers to web servers. Let's Encrypt certificate is a free, open and automated certificate authority that you can use to encrypt your site. The certificate expires after every 90 days and auto-renews at absolutely no cost.


To Install Certbot in CentOS 8.

Certbot is a client that automates the installation of the security certificate. It fetches the certificate from Let's encrypt authority and deploys it on your web server without much of a hassle.

1. Before downloading certbot, first, install packages that are necessary for the configuration of an encrypted connection:

$ sudo dnf install mod_ssl openssl

2. Download certbot using the curl command:

$ sudo curl -O https://dl.eff.org/certbot-auto

3. Next, move the certbot file to the /usr/local/bin directory and assign the execute file permissions:

$ sudo mv certbot-auto /usr/local/bin
$ sudo chmod 755 /usr/local/bin/certbot-auto


To Assign the permissions to the Document root of a domain:

$ sudo chown -R apache:apache /var/www/domain.com

For the changes to come into effect, restart the Apache service:

$ sudo systemctl restart httpd

Read More

Install Apache on Ubuntu 18.04 - Step by Step Process ?

This article covers how to successfully install Apache on your Ubuntu 18.04 server. The Apache HTTP server is the most widely-used web server in the world. It provides many powerful features, including dynamically loadable modules, robust media support, and extensive integration with other popular software.


To install Apache on Ubuntu:

1. Update your local package index:

$ sudo apt update

2. Install the apache2 package:

$ sudo apt install apache2

Read More

Install MySQL on CentOS 7 Server - Step by Step Process ?

This article covers how to install and secure a MySQL server on a CentOS 7 server. MySQL is one of the most widely used database management systems for websites and server applications.


To start the MySQL server daemon with the following command:

$ sudo systemctl start mysqld

systemctl doesn't display the outcome of all service management commands, so to be sure we succeeded, we'll use the following command:

$ sudo systemctl status mysqld

To configure MySQL, run the following command:

$ sudo mysql_secure_installation

To Current MySQL Version, run the command:

$ mysql -u root -p


Terms used in Managing MySQL User Permissions:

  • SELECT – users can read through the database using the select command.
  • CREATE – they can generate new tables.
  • DROP – allows users to remove tables.
  • DELETE – users can take out rows from tables.
  • INSERT – lets users add in rows into tables.
  • UPDATE – enable them to update the rows.
  • GRANT OPTION – they can grant or remove the privileges of other users.

Read More

Configure Apache Virtual Hosts on CentOS 7

This article covers method to easily configure Apache virtual hosts. You repeat same procedure for multiple domain.

You can use yum to install Apache through CentOS's default software repositories:

$ sudo yum -y install httpd

Next, enable Apache as a CentOS service so that it will automatically start after a reboot:

$ sudo systemctl enable httpd.service


How to Set Up Local Hosts File ?

If you are on a Mac or Linux computer, edit your local hosts file with administrative privileges by typing:

$ sudo nano /etc/hosts

The details that you need to add are the public IP address of your VPS followed by the domain that you want to use to reach that VPS:

127.0.0.1   localhost
127.0.1.1   guest-desktop
server_ip_address example.com
server_ip_address example2.com

This will direct any requests for example.com and example2.com on our local computer and send them to our server at server_ip_address.

Read More

Resources