Howto mariadb server: Difference between revisions

From Vidalinux Wiki
Jump to navigation Jump to search
(Created page with "= 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 s...")
 
Line 9: Line 9:
  systemctl start mariadb
  systemctl start mariadb
  systemctl enable mariadb
  systemctl enable mariadb
connect to your database server:
mysql -u root -h localhost -p

Revision as of 19:50, 12 August 2020

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