Geek Freely: HOWTO: MySQL install guide for NAS4Free 10.2.x

    Featured Post

    The whole point in this post is to run your own VPN service, and allow you to connect remote devices to your home network.

    To start off yo…

    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

    2 comments:

    said…

    Acually, I recently saw your post, This is very nice and

    I feel good to see your post. I am always following your blog, Continue posting…

    said…

    Information’s are Very Impressive…I Grasp a lots of Knowledge’s from your Site…Big Thanks For all… |

    |

    |

    |

    |

    Subscribe to:

    Labels

    Blog Archive

    Links

    Leave a Reply

    Your email address will not be published.

    Geek Freely: HOWTO: MySQL install guide for NAS4Free 10.2.x

    Featured Post

    The whole point in this post is to run your own VPN service, and allow you to connect remote devices to your home network.

    To start off yo…

    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

    2 comments:

    said…

    Acually, I recently saw your post, This is very nice and

    I feel good to see your post. I am always following your blog, Continue posting…

    said…

    Information’s are Very Impressive…I Grasp a lots of Knowledge’s from your Site…Big Thanks For all… |

    |

    |

    |

    |

    Subscribe to:

    Labels

    Blog Archive

    Links

    Leave a Reply

    Your email address will not be published.