Why MariaDB and not MySQL?

I switched to MariaDB over a decade ago when I was writing databases. It is easier to upgrade. Less glitchy issues with the databases. phpMyAdmin seems to work better with it. It is based on MySQL.

How to install mariaDB

sudo apt-get install apt-transport-https curl
sudo mkdir -p /etc/apt/keyrings
sudo curl -o /etc/apt/keyrings/mariadb-keyring.pgp ‘https://mariadb.org/mariadb_release_signing_key.pgp‘

Once the key is imported, copy and paste the following into a file under /etc/apt/sources.list.d (for instance /etc/apt/sources.list.d/mariadb.sources)

MariaDB 11.2 repository list – created 2023-12-25 22:01 UTC

https://mariadb.org/download/

X-Repolib-Name: MariaDB
Types: deb

deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.

URIs: https://deb.mariadb.org/11.2/ubuntu

URIs: https://mirror.its.dal.ca/mariadb/repo/11.2/ubuntu
Suites: jammy
Components: main main/debug
Signed-By: /etc/apt/keyrings/mariadb-keyring.pgp

sudo apt-get update
sudo apt-get install mariadb-server

If you prefer to use the old “one-line-style” APT format, create the file /etc/apt/sources.list.d/mariadb.list with the following:

MariaDB 11.2 repository list – created 2023-12-25 22:01 UTC

deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.

deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/11.2/ubuntu jammy main

deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.its.dal.ca/mariadb/repo/11.2/ubuntu jammy main

MariaDB 11.2 repository list – created 2023-12-25 22:03 UTC

deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.

deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/11.2/ubuntu jammy main

deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.its.dal.ca/mariadb/repo/11.2/ubuntu jammy main

# MariaDB 11.2 repository list – created 2023-12-25 22:03 UTC # https://mariadb.org/download/ # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details. # deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/11.2/ubuntu jammy main deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.its.dal.ca/mariadb/repo/11.2/ubuntu jammy main # deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.its.dal.ca/mariadb/repo/11.2/ubuntu jammy main