• 1
  • 37
  • 38
  • 39
  • 40
  • 41(current)
HOW-TO:Share libraries using MySQL: Wiki Edition
(2024-01-25, 01:32)flhthemi Wrote: So..I've been using MySql on Kodi Windows for a long time....just wondering if Kodi 21 can use a version of MySql higher than 5.7 as I'm getting ready to do a fresh Kodi 21 install on Windows 11.

I have wondered this as I am still on Kodi 20 and using 5.6. And just don't want to break anything to update
Reply
(2024-07-10, 17:59)clones Wrote:
(2024-01-25, 01:32)flhthemi Wrote: So..I've been using MySql on Kodi Windows for a long time....just wondering if Kodi 21 can use a version of MySql higher than 5.7 as I'm getting ready to do a fresh Kodi 21 install on Windows 11.

I have wondered this as I am still on Kodi 20 and using 5.6. And just don't want to break anything to update

You see how long I've been waiting for an answer, guess no one really knows. I might just try the newest version and see what happens.

EDIT

The WIKI for Windows says Important: Please use only supported versions of the MySQL or MariaDB server. As of January 2019, this is MySQL in at least version 5.7 or MariaDB in at least version 5.5, but version 10.3+ is recommended

So I just installed V8.0.38 along with the Workbench on an extra PC I have and Kodi 21 is, as I type this, scanning in my movies. Not much of a test but I guess I'll see what happens.

Kinda sad the WIKI hasn't been updated in 5 years...
Reply
(2024-07-10, 23:46)flhthemi Wrote:
(2024-07-10, 17:59)clones Wrote:
(2024-01-25, 01:32)flhthemi Wrote: So..I've been using MySql on Kodi Windows for a long time....just wondering if Kodi 21 can use a version of MySql higher than 5.7 as I'm getting ready to do a fresh Kodi 21 install on Windows 11.

I have wondered this as I am still on Kodi 20 and using 5.6. And just don't want to break anything to update

You see how long I've been waiting for an answer, guess no one really knows. I might just try the newest version and see what happens.

EDIT

The WIKI for Windows says Important: Please use only supported versions of the MySQL or MariaDB server. As of January 2019, this is MySQL in at least version 5.7 or MariaDB in at least version 5.5, but version 10.3+ is recommended

So I just installed V8.0.38 along with the Workbench on an extra PC I have and Kodi 21 is, as I type this, scanning in my movies. Not much of a test but I guess I'll see what happens.

Kinda sad the WIKI hasn't been updated in 5 years...
Was it pretty straightforward to update? I had also seen that there is a command needed to be added for 5.7 and above to the password does not expire
Reply
(2024-07-12, 02:02)clones Wrote:
(2024-07-10, 23:46)flhthemi Wrote:
(2024-07-10, 17:59)clones Wrote: I have wondered this as I am still on Kodi 20 and using 5.6. And just don't want to break anything to update

You see how long I've been waiting for an answer, guess no one really knows. I might just try the newest version and see what happens.

EDIT

The WIKI for Windows says Important: Please use only supported versions of the MySQL or MariaDB server. As of January 2019, this is MySQL in at least version 5.7 or MariaDB in at least version 5.5, but version 10.3+ is recommended

So I just installed V8.0.38 along with the Workbench on an extra PC I have and Kodi 21 is, as I type this, scanning in my movies. Not much of a test but I guess I'll see what happens.

Kinda sad the WIKI hasn't been updated in 5 years...
Was it pretty straightforward to update? I had also seen that there is a command needed to be added for 5.7 and above to the password does not expire

I am far from being well versed in MySql, in fact I'm a Super N00b...so I didn't seem to have an issue with the password thing...I could not import the data from the existing V5.6 export to a single file. There was some sort of error. I did let the new install scan in my movies, TV show and music. It SEEMS to have worked fine.

I installed Kodi 21 and then copied my entire \AppData\Roaming\Kodi folder from another PC
BEFORE I started Kodi I edited the advancedsettings.xml file to reflect the new IP and port for MySql. I used port 3304 because I still have Mysql running for my main system.
All the sources for my folders/files then existed in the fresh install of Kodi and I just used the context menu for each folder to set the content to the appropriate type for that folder and then let it scan each folder one at a time.

Today I want to check the 5.6 data against the 8.0.38 to see if anything might have been missed. But so far it went smooth. More time will tell and I think I may point one of my other kodi installs to it and see how that goes.
Reply
Any luck with 8 and 21? I'm trying to get 9.2 to work with 22.
Reply
(2025-02-04, 01:44)Qbert64 Wrote: Any luck with 8 and 21? I'm trying to get 9.2 to work with 22.
mysql 8.4.4 on Linux works good here with multiople kodi 21 client setups. I have no need for mysql 9 yet. v8 is EOL in 2026, so there is still time.
mysql 8.4.x is the LTS version, mysql 9.2.0 "Innovation" is more likely a alpha/beta version with bigger options to crash IMO.
Reply
(2025-02-04, 11:52)Testkees Wrote:
(2025-02-04, 01:44)Qbert64 Wrote: Any luck with 8 and 21? I'm trying to get 9.2 to work with 22.
mysql 8.4.4 on Linux works good here with multiople kodi 21 client setups. I have no need for mysql 9 yet. v8 is EOL in 2026, so there is still time.
mysql 8.4.x is the LTS version, mysql 9.2.0 "Innovation" is more likely a alpha/beta version with bigger options to crash IMO.
No you misunderstand the expression, Oracle says:
"The MySQL release model is divided into two main tracks: LTS (Long-Term Support) and Innovation. All LTS and Innovation releases include bug and security fixes, and are considered production-grade quality."

And next LTS will be 9.7. (LTS is only about long time support needed by enterprices.)
https://docs.oracle.com/cd/E17952_01/mys...eases.html
Reply
Okay. I did not read entire Oracle/Mysql website.
Reply
  • 1
  • 37
  • 38
  • 39
  • 40
  • 41(current)

Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2