Working with MySQL 8.0
lazarus / 16-Databases

----------------------------------------------------------------------
svtdoug · 2021-11-15 03:26

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 · 2021-11-15 07:26

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 · 2021-11-22 03:41

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 · 2021-11-22 10:10

Why didn't you use Zeos?

Michał

----------------------------------------------------------------------
funlw65 · 2021-11-23 16:28

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?