Working with MySQL 8.0

[svtdoug]

Hey, after installing Lazarus, I am up and running.  I love the IDE, has all that was nice about Delphi IDE before it got harder to use.  I really like the classic un-docked desktop. 

I am trying to connect to a MySQL server which is running 8.0.  I tried using the supplied mySQL components - the latest being MySQL57Connection.  Weill, not suprising I get a version mismatch error when trying to connect.  So what is the work around for this?  I suspect Zeos components is one avenue.  Are there other native components I have not found?  Maybe I should try TSQLConnector?  Checked that out and the highest it goes is MySQL 5.7 also. 

Thanks for any clues.

Doug

[Zvoni]

Which FPC/Laz-Version?
Support for MySQL80 has been added for FPC3.2.2
https://wiki.freepascal.org/FPC_New_Features_3.2.2

[svtdoug]

Thanks for suggestion.  I am using Lazarus IDE v2.2.0RC2.  I was able to install FPC3.2.2 and found the MyQSL80Connection component.  But using that component along with SQLQuery and Datasource with DBGrid - still not able to with my MySQL DB.  In design time, with the MySQL80Connection I can set Connected to True (no errors) but when I set the SQLQuery to active, I get an error "Unable to open file "mytestdb";  the system cannot find the file specified." 

The file is there, check the name dozens of times.  This is same arrangement which is working in Delphi 10.4.2 with either FireDAC or Zeos components. 

I really want to get away from Embarcadaro! 

Thanks for any hints.
Doug


// Edit // 
Never mind.  I figured it out.  Have to use a QSLTransaction component between the SQLQuery and Connection.   That's different than Delphi with Zeos...   learning!

Doug

[miab3]

Why didn't you use Zeos?

Michał

[funlw65]

From his comments, he knows how to use ZEOS. But I guess he need to learn about  the online package manager and about compiling IDE?