Install and Setup

    Published: 2022-09-21
    Updated: 2023-11-08

    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