Managing MySQL (MariaDB) for Local Use on Arch Linux

So I can run small projects locally like journaling and stuff.

Installation

sudo pacman -S mariadb

sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

sudo systemctl enable mariadb

sudo systemctl start mariadb

sudo mysql_secure_installation

mysql -u root -p

Can’t login?

sudo mariadb

USE mysql;

ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('yourpassword');

FLUSH PRIVILEGES;

EXIT;

New User and Database

CREATE DATABASE mydb;
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;