Install and Setup

Tested OS

This setup was done and tested on Ubuntu 22.04

Source: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-22-04

Install MariaDB

sudo apt install mariadb-server

Start

sudo systemctl start mysql.service

Configure

As of July 2022 mysql_secure_installation will produce an error due how it attempts connection. This error results in a loop.

Open SQL command prompt

See instructions here.

Set root password

Replace p@s$w0rD by a suitable strong password.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'p@s$w0rD';

Close SQL command prompt

exit

You will no longer be able to access mysql using sudo mysql

Run command to secure installation

Now secure the setup. Run the command and follow the steps as appropriate.

sudo mysql_secure_installation