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
```
No comments:
Post a Comment