MySQL5.7 Lazarus 1.8.0 RC5-32
lazarus / 38-Networking and Web Programming

----------------------------------------------------------------------
eraaijma · 2017-11-17 23:00

No matter what I try, I cannot get Lazarus to connect to my MySQL5.7
server

This version connects very well to MySQL5.6 and to MariaDB 10.2.
I have found a libmysql.dll that makes this happen.

MySQL5.7 is another story.
After downloading 'TOAD for MySQL8.0' I can see that the server is
willing and able.
So I think that the problem is in the combination of libmysql.dll and
MySQL57Connection.

Question: What do I need besides MySQL57Connection to connect to a
MySQL57 server?
Help is appreciated

----------------------------------------------------------------------
balazsszekely · 2017-11-18 06:26

Please read this post: http://forum.lazarus.freepascal.org/index.php/t
opic,38780.msg264849.html#msg264849 In fact you can read the whole
thread if you like. The issue is very similar to yours, the good news
is the component works fine. Please note the OP from the other post
use 64 bit Lazarus. This is the only difference as far as I can see.

----------------------------------------------------------------------
eraaijma · 2017-11-18 09:44

@getmem
Thanks for your support. I have downloaded the libmysql version in the
post. I followed all the steps and ended up with a working system

Please note however:
Connection with the MySQL57 server is now established by using
TMySQL56connection.
As soon as I use the TMysSQL57Connection, it won't connect. Just a
little confusing.

----------------------------------------------------------------------
eraaijma · 2017-11-18 10:31

@getmem
I got it firing on all cylinders now! the 32-bits version works as
well.
Great!
I used my existing libmysql.dll
set the port to 3306
prevented a library check
and there we go!

Thanks again

----------------------------------------------------------------------
balazsszekely · 2017-11-18 13:14

@eraaijma

You're welcome. I'm glad it's working.