MySQL wrong version again
lazarus / 16-Databases

----------------------------------------------------------------------
TyneBridges · 2020-06-12 15:36

I'm trying to connect to both SQLite and MySQL in a non-visual
application (a Windows 10 service). SQLite was easy but MySQL is
giving a familiar problem with my test application:

Code: Text  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
TMySQL57Connection can not work with the installed MySQL client
version: Expected (5.8), got (8.0.19)
I see that providing a FreePascal library for MySQL 8 is on the "to
do" list, but has been since 2018. Is there any way round this (that
is, any simple way I can connect a nonvisual application to MySQL
8.0.19) or do I need to swap my database software for a system that
maintains compatibility across versions?

Incidentally, does this incompatibility also extend to the Lazarus
visual components? I haven't tried those with MySQL yet but will also
need to connect them, so I guess I may have to look at changing my
database server.

I hope I'm forgiven for re-raising this. I can see it's been discussed
before but all the previous mentions I've found are from several years
ago and things may have changed.

Thanks.

(I've just spotted that there's a separate FreePascal board where this
should probably be, but the forum won't let me delete so I can repost
it.)

----------------------------------------------------------------------
LacaK · 2020-07-26 14:47

Try set TMySQL57Connection.SkipLibraryVersionCheck to True
This will skip library version check

----------------------------------------------------------------------
willbprog9933 · 2020-07-26 16:00

Quote from: LacaK on July 26, 2020, 04:47:48 pmTry set
TMySQL57Connection.SkipLibraryVersionCheck to True
This will skip library version check 

Wow, thanks for this!