This page is outdated. The MariaDB packaging status and current info is maintained at https://wiki.debian.org/Teams/MySQL/MariaDB
MariaDB is a popular relation database management system which emerged as a fork of MySql. MariaDB has replaced MySQL in Debian since Debian 9 Stretch in 2017.
This page is intended to document issues that are Debian centric. Please contribute any issues you run into. For more detailed documentation, see the Further information section.
Installation
To install the MariaDB database server using apt:
apt install mariadb-server
Installing the server package as above will also install the MariaDB client. If you only need to install the client you can instead run:
apt install mariadb-client
MariaDB version by Debian release
Debian Release |
MariaDB Version |
Initial server access
By default MariaDB server will install with a root user, which you can access using the MariaDB command line client as the root user of the same system:
mariadb # Alternatively, using sudo when not logged in as root: sudo mariadb
On access, you should see a welcome message along with version details for the MariaDB server you're connected to. You'll then land in an interactive SQL shell, noticeable by a change of command line prompt to MariaDB [(none)]>. The (none) portion of the prompt indicates that no database is currently selected, and this will change to the database name when a specific database is selected.
Why to migrate from mysql
*Why to migrate mysql is now owned by Oracle Corporation - new features - freedom matters.
How to migrate from mysql
Preparation
* Backup steps
- One
- two
upgrade instructions from mariadb
Further information
/usr/share/doc/mariadb* - Local documentation