stuff/os/FreeBSD/Bastille/MariaDB.md

MariaDB

bastille pkg alcatraz install -y mariadb114-server mariadb114-client

Repeat the message:

bastille pkg alcatraz info -D mariadb114-server 

Enable and start

bastille sysrc alcatraz mysql_enable=YES
bastille service alcatraz mysql-server start

Create nextcloud database and user

bastille cmd alcatraz mysql

CREATE DATABASE nextcloud;
CREATE USER 'nextcloud'@'192.168.1.201' IDENTIFIED BY '1234sys!';
GRANT ALL PRIVILEGES ON nextcloud.* TO 'nextcloud'@'192.168.1.201';
FLUSH PRIVILEGES;