OpenBSD set up MariaDB database server
How do I set up MariaDB database servers on OpenBSD Unix working techniques?
Introduction: MariaDB is a drop in substitute for Oracle MySQL servers. MariaDB is a multithreaded SQL database with a command syntax similar to mSQL. This web page exhibits how to put in MariaDB server on OpenBSD. There are two packages of MariaDB on OpenBSD 6.four mariadb-server – The MariaDB server.mariadb-client – The consumer aspect of MariaDB server together with mysqlclient library and headers for the MariaDB consumer API.
Learn how to seek for MariaDB packages
Run the next pkg_info command together with grep command:
pkg_info -Q mariadb
Seek for PHP consumer that may entry mariadb server:
pkg_info -Q mariadb | grep php
OpenBSD set up MariaDB database server utilizing pkg_add
Kind the next pkg_add command to put in MariaDB on OpenBSD 6.four:
# pkg_add -v mariadb-server
OR
$ doas pkg_add -v mariadb-server
Learn how to set up MariaDB consumer on OpenBSD
Merely run:
# pkg_add -v mariadb-client
OR
$ doas pkg_add -v mariadb-client
Learn how to allow and begin MariaDB server at boot time on OpenBSD
To configure and management daemons and providers on OpenBSD use rcctl command
Allow MariaDB
# rcctl allow mysqld
OR
$ doas rcctl allow mysqld
Initialize MariaDB information listing
You might want to run mysql_install_db command. It initializes the MariaDB information listing and creates the system tables:
# mysql_install_dbConfigure MariaDB on OpenBSD 6.x
Begin MariaDB service on OpenBSD
# rcctl begin mysqld
Cease MariaDB service on OpenBSD
# rcctl cease mysqld
Restart MariaDB service on OpenBSD
# rcctl restart mysqld
Test MariaDB service standing on OpenBSD
# rcctl examine mysqld
Confirm that MariDB service working and port is open
Run pgrep command to searche the method named mysqld:
# pgrep mysqld
An alternative choice is to run ps command:
# ps aux | grep mysqld
Confirm that TCP port 3306 is open utilizing netstat command:
# netstat -f inet -na
# netstat -f inet -na | grep 3306
Learn how to safe MariaDB set up
Run the next script:
# mysql_secure_installationSecuring MariaDB server installations to keep away from compromising server
Learn how to take a look at MariaDB set up
Run the next mysql command:
mysql -u root -p
Learn how to configure MariaDB on OpenBSD 6.four
Edit /and so on/my.cnf file:
# vi /and so on/my.cnf
For instance, change IP deal with binding from localhost:
bind-address = 127.zero.zero.1
To LAN IP deal with 192.168.2.200:
bind-address = 192.168.2.200
Save and shut the file. Restart mysqld service on OpenBSD:
# rcctl restart mysqld
Learn how to open MariaDB port utilizing PF firewall on OpenBSD
Merely add the next rule to /and so on/pf.conf
move in proto tcp from 192.168.2.zero/24 to any port 3306 preserve state
Check it and reload the principles:
# pfctl -v -nf /and so on/pf.conf
# pfctl -v -f /and so on/pf.conf
Conclusion
You realized learn how to arrange and set up MariaDB on OpenBSD. For extra info see the official MariaDB web site right here and pkg_add web page right here.