I found these instructions to install MariaDB Servers in OpenBSD.
(They're for OpenBSD v6.4.)
Any changes for 7.5, please, or should I just 'send it'?
(From the 'It's better to ask than to be told 'If only you'd asked.'',
file.)
Thanks, in advance ...
*``` OpenBSD install MariaDB database server*
# pkg_add -v mariadb-server
*How to enable and start MariaDB server at boot time on OpenBSD*
# rcctl enable mysqld
*Initialize MariaDB data directory*
You need to run mysql_install_db command. It initializes the MariaDB
data directory and creates the system tables:
# mysql_install_db
*Start MariaDB service on OpenBSD*
# rcctl start mysqld
*Stop MariaDB service on OpenBSD*
# rcctl stop mysqld
*Restart MariaDB service on OpenBSD*
# rcctl restart mysqld
*Check MariaDB service status on OpenBSD*
# rcctl check mysqld
*Verify that MariDB service running and port is open*
*
/Run pgrep command to search the process named mysqld:/*
# pgrep mysqld
*/Another option is to run ps command:/*
# ps aux | grep mysqld
*Verify that TCP port 3306 is open using netstat command:*
# netstat -f inet -na
# netstat -f inet -na | grep 3306
*How to secure MariaDB installation*
*/Run the following script:/*
# mysql_secure_installation
*How to test MariaDB installation*
*
/Run the following mysql command:/*
mysql -u root -p
*How to configure MariaDB on OpenBSD*
*/Edit /etc/my.cnf file:/*
# vi /etc/my.cnf
/
*For example, change IP address binding from localhost:*/
bind-address = 127.0.0.1
To LAN IP address 192.168.2.200:
bind-address = 192.168.2.200
/*Save and close the file. Restart mysqld service on OpenBSD:*/
# rcctl restart mysqld
*How to open MariaDB port using PF firewall on OpenBSD*
*/Simply add the following rule to /etc/pf.conf/*
pass in proto tcp from 192.168.2.0/24 to any port 3306 keep state
*Test it and reload the rules:*
# pfctl -v -nf /etc/pf.conf
# pfctl -v -f /etc/pf.conf
```
