sudo pacman -S mariadb sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql #optional#sudo systemctl enable mariadb.service sudo systemctl start mariadb.service mysql_secure_installation mysql -u root -p CREATE USER 'username'@'localhost' IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'localhost'; FLUSH PRIVILEGES; create database moo; show databases; use moo; show tables; create table animals( num int(2), name varchar(10), location varchar(10), primary key(num)); describe animals; insert into animals ( num , name,location) values(1,'tiger','mountains'); select * from animals; drop table animals;