My QNAP NAS is running the latest firmware available to it, but the device itself is a few years old. Anyways, it had preinstalled mySQL which was able to be enabled, but that version is 5.1.73 and it appears mySQL is now up to v8.0.13.
I’ve no idea if the current version of mySQL can be installed onto my NAS. Probably can but that’s likely another project in of itself. The download page for mySQL is here.
Once mySQL (v5.1.73) is enabled, you get a message (on the QNAP NAS) that you can install “myPHPadmin” to manage your mySQL server. However that doesn’t work. Not right away.
This person “HANS” in an old 2013 thread provided nice instructions for getting it going. Things look different now and are in different places but more or less, you have to also enable “Web Server” on your QNAP NAS. The default username + password for mySQL (which I never changed) did not work, so I had to reset it – there’s a link/button to click on the mySQL page on the NAS --and then I was finally able to use myPHPadmin.
Note, the version of myPHPadmin used, is v4.0.10.20 – Older version compatible with PHP 5.2 and MySQL 5. Does not support PHP 5.5 or newer. Was supported until April 1, 2017. Read about that here.
“Hans” also has an article about this same topic, but it also is from 2013.
As Hans points out, within myPHPadmin there is a tab called “SQL” that allows you to copy & paste and click “GO” to execute the commands listed in the kodi wiki, namely:
- Type in:
CREATE USER 'kodi' IDENTIFIED BY 'kodi';and press return (click GO)- Type in:
GRANT ALL ON *.* TO 'kodi';and press return (click GO)- Type in:
flush privileges;and press return (click GO)
And then after that, you can click on the USERS tab to see that the user ‘kodi’ was created. On that same tab there is a button called ‘Add User’ but I did not do that because as a newb I am trying to explicitly follow the instructions.
That’s as far as I’ve made it.