MySQL on CentOS 7 featured image

How to Install MySQL on CentOS 7

MySQL is one of the most popular database management systems for websites and server applications. For webmasters, it is an essential tool to learn. MySQL is a relational database that uses SQL (Structured Query Language) for managing its data. MySQL is commonly installed as a part of the LEMP stack that contains Linux, Nginx, MySQL/MariaDB, and PHP/Perl/Python. You should have …

PaaS Top Ten Cloud Applications featured image

Top ten cloud applications you can deploy with one click on CloudSigma

Whether you are running a small business or a large-scale organization, there is no doubt that you need 3rd party tools to achieve the required results. Fortunately, there are a ton of modern solutions that are specifically designed to make your job easier. You can extract a lot of use and functionality from these applications. However, they are simply not …

phpBB featured image

Installing phpBB on Ubuntu 20.04

PhpBB stands for “PHP Bulletin Board.” It’s a free flat-forum bulletin board software solution. It’s licensed under the GPL license as free and open-source software. PhpBB can instantly establish a dedicated space for people to gather and communicate. It also supports popular database engines (MySQL, Oracle Database, SQLite, PostgreSQL, etc.), flat message structures, hierarchical sub-forums, user groups, full-text search, plugins, …

Iptables Firewall featured image

Configuring an Iptables Firewall: Basic Rules and Commands

Introduction Iptables​ is a command-line ​firewall ​utility. This means that it is software that allows you to configure a firewall on your system. It is typically available by default on ​Linux​ systems. In this guide, we will ​discuss some of the common rules and commands that go with the iptables​ firewall. Whenever a connection tries to establish itself with your …

service crash part 2 featured image

How to Configure a Linux Service to Auto-Start After a Reboot or System Crash: Part 2 (Theoretical Explanations)

In this second installment of the two-part tutorial on configuring Linux services to start automatically after a reboot or system crash, we will discuss the init system in detail. You can refer to Part 1 of the series: How to Configure a Linux Service to Auto-Start After a Reboot or System Crash: Practical Examples here. The current tutorial will be …

System Crash featured image

How to Configure a Linux Service to Auto-Start After a Reboot or System Crash: Part 1 (Practical Examples)

Introduction In computing, things don’t always go as planned. Oftentimes unexpected system crashes prompt system admins to initiate reboots and restart of individual services. Figuring out and restarting every service your application needs to run after a system crash or reboot can be tedious. In this first installment of the two-part tutorial, we will show you how to configure services …

Relational Database Management Systems Compared featured image

SQLite vs MySQL vs. PostgreSQL: Relational Database Management Systems Compared

Introduction Database management tools are mostly used by the relational data model. This model organizes data into tables consisting of columns and rows. While this model remains dominant in terms of storing and managing worldwide data, there are other data models such as NoSQL and NewSQL out there. In this tutorial we will delve into three of the most widely …

Laravel featured image

Deploying Laravel, Nginx, and MySQL with Docker Compose

Introduction Continuous Integration (CI) and Continuous Deployment (CD) are some of the most trending topics in software development currently. To achieve the CI/CD aspect of software architecture, developers make use of containers. Containers are lightweight, virtualized, portable, software-defined environments. In containers, the software can run in isolation of other software running on the physical host machine. The focus of this …

UFW featured image

The Basics of UFW: Learning the Essential Firewall Commands 

Introduction UFW stands for uncomplicated firewall. It is a frontend platform that enables you to easily manage your firewall functions and commands. You get UFW as a default option with your Ubuntu server. Maximizing the potential of the commands and functions of the firewall can be difficult if you are not already familiar with the tool. Our goal is to …

phpMyAdmin

Installing and Securing phpMyAdmin on Ubuntu 18.04

MySQL is an open-source RDBMS based on SQL queries. It’s easy to use, secure, free, and open-source (under the GNU license). In addition, it is highly flexible, memory efficient, and high-performance. Because of all these features, MySQL finds its way in even the top-tier industries. When working with MySQL, most of the time, the interactions occur through the MySQL CLI …

LAMP Stack featured image

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on CentOS 7

LAMP is an acronym of a very popular web stack – Linux, Apache, MySQL, PHP. All of the four components of LAMP are open-sourced and are suitable to deploy dynamic websites and web applications. In this tutorial,  we will walk you through setting up a cloud server with the LAMP stack. LAMP Stack: L – Linux L in LAMP stands for …

LEMP stack featured image

How to Install the LEMP stack (Linux, Nginx, MySQL PHP) on Ubuntu 20.04

Introduction In the world of the internet, several technologies come together to form a solution that enables internet users to access dynamic content on the world wide web. LEMP stack is one of those solutions. It brings together four technologies that make a complete server solution for high-performance and dynamic websites. LEMP is an acronym for Linux, Nginx, MySQL, and …