Howto mariadb server

From Vidalinux Wiki
Jump to navigation Jump to search

install mariadb on archlinux

install the package:

pacman -S mariadb

create the mariadb datadir:

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

secure your mariadb installation:

mysql_secure_installation

start and enable mariadb service:

systemctl start mariadb
systemctl enable mariadb

connect to your database server:

mysql -u root -h localhost -p