Install MariaDB Databases on a FreeBSD 11 Unix Server

To install MariaDB, a popular open-source database management system, on a FreeBSD 11 server, follow these steps:

1. Add the MariaDB package repository to your system's package sources by running the following command:

pkg install -r mariadb

2. Install MariaDB by running the following command:

pkg install mariadb102-server

This will install the MariaDB server and client programs, as well as any dependencies required.

3. Enable the MariaDB service to start automatically at boot time by running the following command:

sysrc mysql_enable=YES

4. Start the MariaDB service by running the following command:

service mysql-server start

5. Secure the MariaDB installation by running the following command:

mysql_secure_installation

This will prompt you to set a root password for MariaDB, as well as to remove anonymous user accounts and disallow remote root login. Follow the prompts to complete the security configuration.

6. Once the installation is complete, you can log in to the MariaDB command line by running the following command:

mysql -u root -p

Enter the root password you set during the security configuration to log in. From the MariaDB command line, you can create and manage databases, users, and other objects.

That's it! You now have MariaDB installed and configured on your FreeBSD 11 server. You can use it to store and manage data for your applications.