Debian install mariaDB

[ysl2]

Install

Install via docker: https://mariadb.com/kb/en/installing-and-using-mariadb-via-docker/

or:

sudo apt install mariadb-server mycli -y
sudo mariadb-secure-installation

Create normal user with root permission

-- Ref: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql
-- Note: `sammy` is your username, `password` is your strong password.
CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password';

Login

If you use docker, use:

mariadb -h 127.0.0.1 -P 3306 -u root -p

else, use:

mariadb -u root -p
mariadb -u sammy -p

[ysl2]

Install via docker: https://mariadb.com/kb/en/installing-and-using-mariadb-via-docker/