How to install MariaDB on Freebsd

[RESOURCES HUB]

Update System​

First, update your package repository:

pkg update
pkg upgrade -y

---

Install MariaDB​

Install MariaDB server and client (example with 10.6):

pkg install mariadb106-server mariadb106-client

If your source requires 10.5, use:

pkg install mariadb105-server mariadb105-client

---

Enable MariaDB at Boot​

Make sure MariaDB starts automatically when the server boots:

sysrc mysql_enable="YES"

---

Initialize Database (FIRST TIME ONLY)​

Before starting MariaDB for the first time, initialize it:

mysql_install_db --user=mysql --basedir=/usr/local --datadir=/var/db/mysql

---

Start MariaDB​

Now start the service:

service mysql-server start

Check if it's running:

service mysql-server status

---

Secure Installation​

Run the security setup:

mysql_secure_installation

Recommended answers:

• Switch to unix_socket authentication → No
• Set root password → Yes
• Remove anonymous users → Yes
• Disallow root login remotely → Yes
• Remove test database → Yes
• Reload privilege tables → Yes

---

Test Login​

Try logging in:

mysql -u root -p

If you enter the MariaDB console, installation was successful


Exit with:

exit