MySQL is free and most widely open-source database management system. MySQL is no longer available since release of Debian 10 and MariaDB has become the default database system. MariaDB is the default database system in Debian 11. This tutorial will describe how to install MySQL on Debian 11 from the MySQL Apt repository. How to
How to Install MySQL on Ubuntu 22.04
MySQL is widely used and popular open-source database management system. MySQL installation on Ubuntu is very easy and it’s commonly being a part of the popular LAMP and LEMP stacks. This article shows you how to install MySQL on Ubuntu 22.04 systems. How to Install MySQL on Ubuntu 22.04# Perform the following steps as root
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. This article will walk through you the process of installing and updating the latest MySQL 8.0 version on RHEL/CentOS 8/7/6/
[Solved] Unknown collation: utf8mb4_0900_ai_ci
A collation means a predefined rules to compare and sort character strings in a database server. Generally, this error occurs during the database restoration on another server. In this guide, we will show you how to fix Unknown collation: utf8mb4_0900_ai_ci error. Let us discuss the cause and solution about the issue: Problem – Unknown collation:
How to Create and Select MySQL Database
MySQL is the most popular and open-source relational database management system. In this article we will show you how to create MySQL or MariaDB database through the command line. Prerequisite# Make sure MySQL or MariaDB is already installed on your system. User account should have privileges to perform actions or have root user account. Connect
BackUp and Restore MySQL/MariaDB Database
The mysqldump is a utility used to backup and restore MySQL or MariaDB database using command line. It is creating a set of SQL statements while taking backup and those are used while restoring. In this tutorial we will show you how to backup and restore MySQL or MariaDB databases from the command line using
How to Check MySQL Version
MySQL is one of the most popular open-source RDBMS (Relational database management system). MySQL provides some features for particular version numbers and on particular platforms only, so knowing which version is running on your server is really important. In this quick tutorial, we’ll explain how to check the MySQL or MariaDB version on your server.
How to Install MariaDB on Ubuntu 20.04
MariaDB is an open-source relational database management system. It was originally designed as a backward-compatible, binary drop-in replacement of MySQL. MariaDB is developed and maintained by the original developers of MySQL and by the open-source community. This guide explains how to install and MariaDB on Ubuntu 20.04. Prerequisites # We’re assuming that you have administrative