Author Topic: MySQL 8?  (Read 1270 times)

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4392
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
MySQL 8?
« on: May 29, 2018, 11:53:54 AM »
I know the majority of people around here use MariaDB for their SQL server but I'm interested to know if anyone has RadioDJ working with MySQL 8

If so how does it handle? Are there any pitfalls or issues with MySQL 8?

Feedback on this would be appreciated.

Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com

How to Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

RadioDJ is the Swiss Army Knife of radio playout software

RadioDJ is my favourite software EVER!

He-j

  • Hero Member

  • Offline
  • *****
  • 560
  • Personal Text
    HEJ say JEH
    • Hej Radio
Re: MySQL 8?
« Reply #1 on: May 29, 2018, 12:23:23 PM »
Hej Gary,

I tried to install it, but I'm still on Windows 7 Pro and it is not compatible with that version of Windows.
So I'm still using MySQL 5.7
Hej Radio ► Netherlands
https://hejradio.jimdofree.com/

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4392
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: MySQL 8?
« Reply #2 on: May 30, 2018, 09:34:38 AM »
I think I've found the answer.... No it won't

http://www.radiodj.ro/community/index.php?topic=10700.msg66205#msg66205

I can't even get database setup to recognise the SQL server & I can't even get the database to install >:D its just not allowing me. so I guess RadioDJ cannot be used with MySQL 8 versions then.

Guess I'll be sticking with MariaDB as at least we know that works and is stable  :bash:
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com

How to Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

RadioDJ is the Swiss Army Knife of radio playout software

RadioDJ is my favourite software EVER!

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4392
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: MySQL 8?
« Reply #3 on: June 06, 2018, 02:16:00 PM »
OK so after looking at the installer again I've managed to get RadioDJ v2.0.0.3 to work with MySQL8

I had to choose "Legacy authentication Method" which isn't ideal but hey at least RadioDJ will connect in that mode.

I know Marius is looking into the authentication issue with the database setup utility.... But this is a work around for the time being if anyone wants to use the updated MySQL server

Updated Tutorial Here

Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com

How to Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

RadioDJ is the Swiss Army Knife of radio playout software

RadioDJ is my favourite software EVER!

He-j

  • Hero Member

  • Offline
  • *****
  • 560
  • Personal Text
    HEJ say JEH
    • Hej Radio
Re: MySQL 8?
« Reply #4 on: June 08, 2018, 08:46:03 AM »
I did a complete new install on a PC with Windows 10 Pro.

As you mentioned and some other people on this forum as well, the only thing is the 'Legacy authentication method', but Marius is working on that.

I didn't have any issues installing MySQL 8. Everything works fine. Even my 'old' soundcard (M-Audio Delta 1010LT) which has no drivers for Windows 10 is working. The drivers of Windows 8 are working on a Windows 10 machine as well.

I have been reading some other posts that people have issues with RadioDJ v2 itself using Windows 10. In my opinion these issues are in most cases driver and/or soundcard related. As you mentioned in some other posts, just take your time installing the software and do it step by step.

Hej Radio ► Netherlands
https://hejradio.jimdofree.com/