MySQL 8.0 support

[rur0]

What behaviour is observed:

Server crashes without starting when using MYSQL storage with MYSQL 8 server

What behaviour is expected:

Server to start and run authme smoothly

Steps/models to reproduce:

enable and configure MYSQL with a MYSQL 8 server

Plugin list:

ProtocolLib, SkinsRestorer, AuthMe

Environment description

PaperMC standalone server with AuthMe MYSQL storage

AuthMe build number:

AuthMe v5.5.1-SNAPSHOT-b2214

Error Log:

https://pastebin.com/D4afV6fP

Configuration:

https://pastebin.com/gM6SyHg6

edit: Also, when I am trying to compile AuthMe, I get this error from maven http://i.imgur.com/osz9Nik.png am I missing some repository ?

[sgdc3]

Spigot's built-in mysql connector doesn't support mysql 8 sadly,, we need to include our own connector library to fix this

[rur0]

So in the meantime I can use any mysql version that is not 8. Or is there a recommended version ?

[ljacqu]

Yes

[TuxCoding]

You could also use MariaDB. It's a fork of MySQL and largely replaced the mysql package in many Linux distributions. However MariaDB 10+ is a major release and it could also contain breaking changes like in MySQL 8 from 5.7.

[TuxCoding]

BTW I noticed that the MySQL connector Spigot currently uses should support MySQL 8. The fix should be included in Connector 5.1.44. This is available in Spigot 1.12.2+

[tommasobenatti]

I'm having this problem too with the latest build downloaded from the CI, please fix