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. This article will walk through you the process of installing and updating the latest MySQL 8.0 version on RHEL/CentOS 8/7/6/
Databases - DesignLinux
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 of database operation. But SQLite has no process running and has no client-server model. SQLite DB is simply an file
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 tables and databases. In this guide, you will learn how to create a new user and grant permissions in the
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 features have been added to MariaDB like new storage engines (Aria, ColumnStore, MyRocks). In this article, we will take a
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 a PostgreSQL database. We assume that you already have a working installation of the PostgreSQL database system. If not, read
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 is one of the common remote database connection errors encountered by users. Test Environment: Application Server IP: 10.24.96.5 Database Server
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 of use. It is the default MySQL type database system in the standard repositories of most if not all major