sudo pacman -S mariadb
initialized data
sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mariadb
sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb
if failed
sudo rm -rf /var/lib/mysql
sudo rm -rf /var/lib/mariadb
sudo mv /var/lib/mysql /var/lib/mysql.bak
sudo mkdir /var/lib/mysql
sudo chown mysql:mysql /var/lib/mysql
sudo chmod 750 /var/lib/mysql
and do initalized again
after that you can
sudo mariadb-secure-installation
Optional, service:
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb
check permission:
sudo chown -R mysql:mysql /var/lib/mysql
sudo chmod -R 750 /var/lib/mysql