Howto mariadb server: Difference between revisions

From Vidalinux Wiki
Jump to navigation Jump to search
Line 2: Line 2:
install the package:
install the package:
  pacman -S mariadb
  pacman -S mariadb
create the mariadb datadir:
create the datadir:
  mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
  mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
secure your mariadb installation:
secure your mariadb installation:

Revision as of 19:51, 12 August 2020

install mariadb on archlinux

install the package:

pacman -S mariadb

create the 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