MySQL / MariaDB Server

pkg install --yes mariadb104-server-10.4.10

/etc/rc.conf
# MySQL
mysql_enable=“YES”

/usr/local/etc/rc.d/mysql-server start


# create db user
CREATE USER 'admin' IDENTIFIED BY 'Passw0rd.';

SELECT User FROM mysql.user;

# allow access from anywhere

grant all privileges on *.* to 'admin' identified by 'Passw0rd.';
flush privileges;