HOWTO: MySQL install guide for NAS4Free 10.2.x

In some of my previous posts I have written about using NAS4Free and installing various extensions on the system, well it was time to upgrade my NAS4Free but I didn't have the space on the Operating System drive - so a complete re-install was looming.

As daunting as it was, it was inevitable that I had to redo everything, but thanks to the new package manager in FreeBSD 10.x this turned out to be an enjoyable exercise.

The first step I decided to tackle was implementing the MySQL DB on NAS4Free, so I could provide a shared DB for Kodi installs.

First let's determine an appropriate location to install the temporary files for installation:

setenv PKG_TMPDIR /mnt/Data

Next let's create the appropriate user and group for the MySQL install in NAS4Free:

Group
Name: mysql
ID: 88

User
Name: mysql
Fullname: mysql
UserID: 88
Primary Group: mysql
NO PASSWORD

After defining the user to access the MySQL DB, the next step was installing MySQL server, using the following commands:

pkg install mysql56-server
rehash
cd /usr/local
mysql_install_db

At this point it is good practice to confirm that MySQL will indeed starts:

/usr/local/etc/rc.d/mysql-server onestart

Hopefully everything is good at this point and, the next step is to make sure that MySQL is enabled in NAS4Free:

nano /etc/rc.conf

Add the following line to the rc.conf file:

mysql_enable="YES"

Now you should be good to go.

If you want to configure this for Kodi to use, check out the following guide:
http://www.geekfreely.com/2015/12/howto-configuring-kodi-to-use-nas4free.html