Up-to-date 32 bit libmysql.dll?

[aehimself 396]

In the prehistoric times, you could download the MySQL C library from their website. Then they changed to the installer-type (download installer, select Connector-C, install 32 bit, copy file, uninstall 32 bit, install 64 bit copy file, uninstall everything).

Now it's even worse.

 

The installer now offers only 6.1.11, but you still can have the latest by downloading MySQL server and copying the file from the Lib folder. My 64 bit Delphi apps are using it happily; but that's only 64 bit, and there's no 32 bit version of MySQL anymore.

The question is: is there a way to get the latest (currently 8.0.18) libmysql.dll in 32 bits?

 

P.s.: I know that libmariadb is a drop-in replacement but I'd prefer the original if possible somehow / somewhere.

[pietrt 1]

I can download the 32 bit installer (8.0.18) here: https://dev.mysql.com/downloads/installer/

You should be able to do so as well?

 

Pieter

[aehimself 396]

Yes, the installer has a 32 bit version, but it only offers the 64 bit server for installation 😞

[Erix A. 8]

Is this the one - http://cdn.mysql.com/Downloads/Connector-C/mysql-connector-c-6.1.11-win32.msi ?

[aehimself 396]

Yes, 6.1.11 is the latest I could find (and therefore have).

I was hoping someone knows where to find a recent version.

 

I honestly think Oracle discontinued it; my hopes are more on unofficial builds (like oss.netfarm.it was for ClamAV).

[microtronx 38]

Any news here? We're also searching for a updated libmysql.dll in 32bit for mysql8. 

[aehimself 396]

I guess no.

LibMariaDB is a valid replacement; the question is, though, until how long they will stay compatible.

[Dmitry Arefiev 101]

Start from this link: https://dev.mysql.com/downloads/c-api/

[Harveyhase68 0]

https://downloads.mysql.com/archives/community/

 

There you select 5.7.36 download the Windows (x86, 32-bit), ZIP Archive and there you have your latest libmysql.dll in 32-bit and yes the "caching sha2 authentication" works, I testet it, and it works with MySQL 8.0! So this is the best solution for me.

 

A real MySQL 8.0 libmysql.dll in 32-bit is not available.

 

[cengo 0]

@Harveyhase68  I've been struggling for this issue since yesterday, you made my day! Many thanks!

[wad11656 0]

On 3/27/2022 at 3:42 AM, Harveyhase68 said:

https://downloads.mysql.com/archives/community/

 

There you select 5.7.36 download the Windows (x86, 32-bit), ZIP Archive and there you have your latest libmysql.dll in 32-bit and yes the "caching sha2 authentication" works, I testet it, and it works with MySQL 8.0! So this is the best solution for me.

 

A real MySQL 8.0 libmysql.dll in 32-bit is not available.

 

The libmysql.dll from 5.7.36 64-bit (not 32-bit) did the trick for my AutoHotkey script after we upgraded to MySQL 8, thank you! (The libmysql.dll from the actual MySQL 8 64-bit .zip release didn't work...Probably due to old AHK code I'm using.) 5.7.36 seems like such a random version number when it comes to supporting MySQL 8, but who cares, I guess.

 

I didn't try the following, but FWIW, somebody on the AutoHotkey forums claims there's a more up-to-date 32-bit MySQL 8 libmysql.dll in the release of HeidiSQL

Edited August 13 by wad11656

[aehimself 396]

Both of libmysql.dll-s in HeidiSQL's bundle seems to have the PE  L header, suggesting they are indeed 32-bit:

 

 

I'll check on them later if they work properly.

 

It would be nice to know the source of these but I have doubts they are official.

Edited August 13 by aehimself

[RDP1974 40]

from ver 8 the dll are inside the c:\program files\mysql\bin folder of the server

latest version needs also a pair of dll crypto ssleay or something for the new ssl protocol auth

Edited August 17 by RDP1974

[RDP1974 40]

On 8/17/2024 at 6:19 PM, RDP1974 said:

from ver 8 the dll are inside the c:\program files\mysql\bin folder of the server

latest version needs also a pair of dll crypto ssleay or something for the new ssl protocol auth

e.c. these dll are only for 64bit latest mysql (copy them from or use the bin folder of the mysql in FDPhysMySQLDriverLink)

Edited August 29 by RDP1974