Comprehensive n00bs Guide on Installing MySQL (and unMENU) to an unRAID Server

[ColonelRhodes]

I am currently running unraid 6.14b

 

I have unmenu installed, but I do not have the mysql pkg listed.

 

Has anyone installed mysql on unraid 6 successfully?

[itimpi]

I would have thought that on v6 it is far more likely to be a docker based solution that a plugin based one?  You might want to look in the docker sub-forum to see if anyone has done MySQL.  I have certainly seen ones like MariaDB done there.

[ColonelRhodes]

I would have thought that on v6 it is far more likely to be a docker based solution that a plugin based one?  You might want to look in the docker sub-forum to see if anyone has done MySQL.  I have certainly seen ones like MariaDB done there.

 

I have looked but everything I see states it was already integrated into Dynamix Web gui. I'm just looking for the simplest mysql database server to run with some apps.

[Squid]

I have looked but everything I see states it was already integrated into Dynamix Web gui. I'm just looking for the simplest mysql database server to run with some apps.

The would be needo's mySQL docker container

[SkyHead]

I tried using your guide, and did all of the following

 

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';  < I changed 'xbmc' to 'kodi'

and

GRANT ALL ON *.* TO 'xbmc';  < I changed 'xbmc' to 'kodi'

on

SELECT host,user from mysql.user;

I got this :

+------+------+

| host | user |

+------+------+

| %    | kodi |

| %    | root |

+------+------+

2 rows in set (0.00 sec)

 

My XML file is  as follows

 

<advancedsettings>

  <videodatabase>

    <type>mysql</type>

    <host>192.168.1.12</host>

    <port>3306</port>

    <user>kodi</user>

    <pass>kodi</pass>

  </videodatabase>

  <musicdatabase>

    <type>mysql</type>

    <host>192.168.1.12</host>

    <port>3306</port>

    <user>kodi</user>

    <pass>kodi</pass>

  </musicdatabase>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

    <importresumepoint>true</importresumepoint>

  </videolibrary>

</advancedsettings>

I copied the advancedsettings.xml to my Kodibuntu htpc and my laptops kodi userdata folder,

and I scanned my library on the htpc, and on the laptop.

 

I tried doing a few "watched" statuses, and rebooting both laptop and htpc without any luck.

 

So I pretty much did all of the steps, and read over the guide currently on kodi's wiki

 

To configure MySQL to listen for connections from network hosts, edit /etc/mysql/my.cnf and change the bind-address directive to the server's IP address:

from: bind-address = 127.0.0.1

to: bind-address = 192.168.0.5

Note: Replace 192.168.0.5 with the appropriate address.

Note: To allow both local and remote access (i.e. from both the MySQL host to itself and also from other clients), either comment out the bind-addres

s using a hash (#) to disable it, or use bind-address = 0.0.0.0 to open it completely.

 

I've done all the steps but these, as I don't know how to adapt it to unraid.

 

my config is pointed at /mnt/cache/mySQL  but I can't find /etc/mysql/my.cnf anywhere to change the bind-adress.

http://kodi.wiki/view/MySQL/Setting_up_MySQL

The quotes part I'm unsure about, do I need to change the bind-adress, and if so. How?

Or can you point out any errors I might have done.

[RobJ]

I tried using your guide, and did all of the following ...

 

SkyHead, you REALLY need to take a closer look at these threads, and make sure they apply to you!  This thread and guide is a very old one for unRAID v5, not v6!  And there's little to no chance you'll get any support here.  It's essentially defunct, like v5.  Try loading the Docker equivalents, of MySQL or MariaDB, from the Community Applications function, the Apps page.