mysql connector 5.6

[xaver13]

Hello, using lazarus I need mysql/c connector libmysqlclient.dylib or libmysqlclient.18.dylib for Tmysql56Connection,  I need 32 bit version.

On dev.mysql.com is only 6.0.2 available  as oldest version to download, it has  libmysqlclient.18.dylib name, but is version 6.1.6 lazarus message is: expected 5.6 got 6.1.6.

Please anybody knows where to download 5.6   libmysqlclient.dylib   32 bit versions? I searched web more times without success. Thanks you very much for help.

[Thaddy]

You didn't look, did you?
Look at this page:
http://dev.mysql.com/downloads/mysql/ and look to the right and previous versions.

BTW: current is 5.7, not 6.0, that is yet to be released. The client lib is included.

And 32 bit what? ARM?

[xaver13]

You didn't look, did you?
Look at this page:
http://dev.mysql.com/downloads/mysql/ and look to the right and previous versions.

BTW: current is 5.7, not 6.0, that is yet to be released. The client lib is included.

And 32 bit what? ARM?

Thank you, Thaddy, your link seems to be to server, server for mac and the appropriate libmysqlclient.dylib there is 64bit. I tried this.. (but ..  I am a beginner     )

I think I need 32 bit version because I have 32 bit Lazarus and even I tried to switch to 64 bit app output, it is not working - message: can not load libmysqlclient.dylib. In that lazarus I have only Tmysql56Connection, nothing newer available. I am a beginner with Lazarus, and ... I tried to find solution whole weekend but without success.  Therefore I started to look for 32 bit dynamic library. And on the same page you mean above is link to connector. And there is 32bit connector for mac. But 6.0.2 is the oldest one there, named (mysql-connector-c-6.0.2-osx10.5-x86-32bit.tar.gz)  link: http://dev.mysql.com/downloads/connector/c/

Or is there any better way for beginner? I have mySQL application working on Windows and I wanted to try it on Mac. Thank you very much for help.

[xaver13]

o.k. I can not found 32 bit libmysqlclient.dylib.  version 5.6 anywhere and no one helped.

I checked in Lazarus project target to x86_64 and received a message that target is not supported.

Lazarus is distributed  in 32bit version for  64bit OS and is compiling 32bit application by default.  And the way to compile 64 bit app is not simple, especially for beginner.
I found a page http://wiki.lazarus.freepascal.org/Cross_compiling#From_Darwin_i386_to_x86_64 and seems that I need to compile fps
$ cd fpc
$ make all CPU_TARGET=x86_64

BUT: it fails in Sierra "fpc No rule to make target `all'.  Stop."       Make on Sierra is 3.81 version. I tried newer but, result seems  to be the same.

And that is the end for me as beginner, I am totally lost.

Can I trust to Lazarus documentation pages? Nothing is working.

[Thaddy]

Ok. If Lacak reads this he can solve it in seconds but otherwise I look into it tomorrow. ok?

[xaver13]

still not solved.

Still 'ElnOutError', TMySQL56Connection can not work wit installed MySQL client version: Expected(5.6), got (6.1.6)

What I can not understand, that Windows libmysql.dll version is 5.6.33 , Mac OS libmysqlclient.dylib is 6.1.6 and I can not find 5.6 even in oldest archives here https://downloads.mysql.com/archives/c-c/  (oldest is 6.0 from Apr 1, 2009 !!!!).
And the newest component TMySQL56Connection in Lazarus is 5.6. 

It is crazy. What do I wrong?   Am I the only one person trying to work with MySQL on the world?     Thank you for any reply.

[Thaddy]

I have no clue. The official Oracle MySql website states the current release is 5.7 not 6.1.
On my MAC mini I have no problems at all.

Also note that the server includes the client.
I have no clue what you are doing, because i can't even find a proper 6.1 release from either the Oracle website or the Mysql community edition.
With MySQL the client NEEDS to match the server. Same version.

And the newest component in FPC (not Lazarus) is 5.7.

[Josh]

Hi

Not sure if this link may help or not; but you can choose which version to download.

http://mac.filehorse.com/download-mysql/4774/

Not sure if you will need to symlink to the dylib to get it to work, as El_Capitan and above have SIP which could interfere with direct access to the library. Unless you temporarily disabled SIP when you installed mysql and re enabled after.

[marcov]

If I look on the site that Thaddy posted, I see a website with a "dev" tab with 6.x, and a "general availability" tab, with 5.5 - 5.7

[xaver13]

Hi

Not sure if this link may help or not; but you can choose which version to download.

http://mac.filehorse.com/download-mysql/4774/

Not sure if you will need to symlink to the dylib to get it to work, as El_Capitan and above have SIP which could interfere with direct access to the library. Unless you temporarily disabled SIP when you installed mysql and re enabled after.

Thank you very much , Josh, it helped! 

[Thaddy]

Hi

Not sure if this link may help or not; but you can choose which version to download.

http://mac.filehorse.com/download-mysql/4774/

Not sure if you will need to symlink to the dylib to get it to work, as El_Capitan and above have SIP which could interfere with direct access to the library. Unless you temporarily disabled SIP when you installed mysql and re enabled after.

You should NOT encourage people to download software binaries from an unofficial source.
As I stated and Marco verified: the OFFICIAL source has 5.7 as the highest official release.
One should use that. And FPC supports it.
You can also use the development version from the OFFICIAL source, we call that trunk. In that case build from sources and adapt the FPC version accordingly
Officially there are no supported distributions 6.X. Be warned.

[dogriz]

Am I right that there is no design time MySQL57Connection component in Lazarus, just as there is no TSQLConnector.ConnectorType for MySQL 5.7? (in 1.6.2 release, fixes and trunk versions - just the same)
Is it posible to add it? I would, but don't know how 

[Thaddy]

5.7 is in trunk.
It does not rely on specific compiler features, so you can simply use the unit.

[dogriz]

5.7 is in trunk.
It does not rely on specific compiler features, so you can simply use the unit.

I do use the unit, but sometimes, doing it through GUI with design time components is more convenient for rapid application development.

[Thaddy]

It is also a component in Lazarus trunk.