Saturday, August 24, 2024

MariaDB install any different for OpenBSD 7.5 than 6.4?

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