Tag: Databases

How to Install MySQL 8.0 on RHEL/CentOS 8/7 and Fedora 35

MySQL is an open-source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database.

How to Install SQLite and SQLite Browser in Ubuntu

SQLite is a lightweight, small and self-contained RDBMS in a C library. Popular databases like MySql, PostgreSQL, etc. works in the client-server model and they have a dedicated process running and controlling all the aspects

How To Create a New User and Grant Permissions in MySQL

MySQL is a popular and widely used database management system that stores and organizes data and allows users to retrieve it. It comes with a vast array of options that grant users certain permissions to

How to Install MariaDB on CentOS 8

MariaDB is an open-source, community-developed relational database management system. It is forked from MySQL and created and maintained by the developers who created MySQL. MariaDB is intended to be highly compatible with MySQL but new

How to Backup and Restore a PostgreSQL Database

In a production environment, no matter how large or small your PostgreSQL database may be, regular back is an essential aspect of database management. In this article, you will learn how to backup and restore

How to Fix ERROR 1130 (HY000): Host is not allowed to connect to this MySQL server

In this quick article, you will learn how to solve the “ERROR 1130 (HY000): Host x.x.x.x is not allowed to connect to this MySQL server” error in MySQL/MariaDB database deployment on a Linux system. This

What is MariaDB? How Does MariaDB Work?

What is MariaDB? How Does MariaDB Work?

MariaDB, a fork of MySQL is one of the most popular open-source SQL (Structured Query Language) relational databases management systems, made by the original developers of MySQL. It is designed for speed, reliability, and ease