Root Password reset featured image

How to Reset MariaDB or MySQL Root Password

MySQL is one of the most popular database systems out there. It’s an open-source relational database management system that follows a client-server model. MySQL is at the core of many of the online services we enjoy on a regular basis. MariaDB is a community-developed fork of MySQL that enjoys commercial support. In the MySQL ecosystem, root is the default user …

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 …

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 …

How-To-Install-and-Use-PostgreSQL-on-Ubuntu-18.04

Setting up PostgreSQL on an Ubuntu 18.04 Server

As time and technology continue to progress, the internet holds a central position in the modern world. That is why most companies and businesses have websites and applications to represent the online aspect of their brands. Regardless of whether you are the owner of a small or large website, you need the help of certain tools to make your job …