MySQL 8.x Setup Info

Use this forum if you want to discuss a problem or ask a question related to a hMailServer beta release.
Post Reply
User avatar
Dravion
Senior user
Senior user
Posts: 2071
Joined: 2015-09-26 11:50
Location: Germany
Contact:

MySQL 8.x Setup Info

Post by Dravion » 2019-01-17 11:58

In MySQL 8.x, a lot has changed, espacially on Windows.

Now you cannot longer simply get any zip archive that easiely as before.
Oracle is trying to force you, to configure, update and modify MySQL 8.x anything with MySQL 8.x Installer.
However. Until hMailServer isnt officiall migrated to MySQL 8.x C Include Headers and its new Binary libs, you need to run it
in MySQL 5.x Legacy mode, see the screenshot.

This will make sure hMailServer 5.x can connect to MySQL 8.x Databases.

However: Since the Major MySQL 8.x Version, MariaDB and MySQL are not longer compatible.
Only a legacy libmysql.dll targeting 5.x will work for MariaDB and MySQL 8.x for a while, until Legacy mode will be removed by
Oracle completeley (there is no date for deprecation, but it will happen - sooner or later).
Attachments
Untitled.png

User avatar
Dravion
Senior user
Senior user
Posts: 2071
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: MySQL 8.x Setup Info

Post by Dravion » 2019-02-06 20:04

There are some Problems downloading the correct version of libmysql.dll for the official hMailServer 5.6.7 32-Bit Releases and later.

First of all, MySQL 8.x 64-Bit and hMailServer 5.6.7 and later 32-Bit (official) runs fine, but Oracle is trying to hide older libmysql.dll
Versions and unware Users can fall quickly into this trap.

The correct (official MySQL) Download localtion for a working libmysql.dll is this
https://downloads.mysql.com/archives/community/
libmysql.dll_5.2x_Download.png
1)
Click version 5.7.24 or a later version within the 5.7.x series and click the red marked download Button (yes, is its a big archive file)
2)
Unzip the mysql-5.7.24-win32.zip and go into the unzipped folder mysql-5.7.24-win32\lib\libmysql.dll
3)
Copy the libmysql.dll to your hMailServer bin Folder - for example: C:\Program Files (x86)\hMailServer\Bin

Now hMailServer can connect to MySQL 8.x 64-Bit as you can see
HMS-5.6.7-32-Bit_Win2019+MySQL8_x64.png

User avatar
Dravion
Senior user
Senior user
Posts: 2071
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: MySQL 8.x Setup Info

Post by Dravion » 2019-02-06 20:19

The 64-Bit Version of the hMailServer LTS-Project (not official) allready includes libmysql.dll in the installer, so no manual download
and configuration is required.

LTSx64_libmysql.dll_included.png
hMailServer-LTS-5.6.7-B2427-x64 - Dowload
https://github.com/Dravion/hMailServer/releases

User avatar
jim.bus
Senior user
Senior user
Posts: 1568
Joined: 2011-05-28 11:49
Location: US

Re: MySQL 8.x Setup Info

Post by jim.bus » 2019-03-08 02:59

The way I got around this problem was to take my libmysql.dll client I used in my old hMailServer version which used MySQL 5.7 (which was a 3 bit version) and used that libmyslq.dll (32 bit version) in my hMailServer which was connected to MySQL 8.0. Apparently you can use the hMailServer (32 bit) libmyslq.dll (32 bit client from MySQL 5.7) when accessing MySQL 8.0. I do believe I did need to specify the legacy version of MySQL 8.0 when installing MySQL.
If you think you understand quantum mechanics, you don't understand quantum mechanics.

Post Reply