Recent

Author Topic: MySQL5.7 Lazarus 1.8.0 RC5-32  (Read 3645 times)

eraaijma

  • New Member
  • *
  • Posts: 26
MySQL5.7 Lazarus 1.8.0 RC5-32
« on: November 18, 2017, 12:00:53 am »
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

  • Guest
Re: MySQL5.7 Lazarus 1.8.0 RC5-32
« Reply #1 on: November 18, 2017, 07:26:02 am »
Please read this post: http://forum.lazarus.freepascal.org/index.php/topic,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

  • New Member
  • *
  • Posts: 26
Re: MySQL5.7 Lazarus 1.8.0 RC5-32
« Reply #2 on: November 18, 2017, 10:44:23 am »
@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

  • New Member
  • *
  • Posts: 26
Re: MySQL5.7 Lazarus 1.8.0 RC5-32
« Reply #3 on: November 18, 2017, 11:31:14 am »
@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

  • Guest
Re: MySQL5.7 Lazarus 1.8.0 RC5-32
« Reply #4 on: November 18, 2017, 02:14:21 pm »
@eraaijma

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

 

TinyPortal © 2005-2018