Devart Forums

I updated MySQL 5.5.11 for MySQL 5.5.12 and Mydac 6.10 does not work

Following error When MyConnection1.open :
#08S01 Bad handshake

Please try connecting to MySQL server with third-party applications, like EMS SQL Manager or any others. If the problem still exist?

Mysql 5.5.12 (64bit or 32bit) gives the handshake error message with Mydac 4 and 5 whilst executing myconnection.open.

MYSQL 5.1 works fine with MYDAC 4 & 5.

EMS works fine with MYSQL 5.5.12

Please help urgently as i upgraded clients database and now my application is unusable

Thanks

Sqlyog works fine with Mysql 5.5.12 (32 and 64)
Mydac works fine with MySql 5.5.11 (32 and 64)
Mydac error with MySQL 5.5.12 (32 and 64)

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

When can we expect the latest MyDAC build?

We are planning to release the new build of MyDAC in two weeks.

Dimon wrote:We are planning to release the new build of MyDAC in two weeks.

Argh!!! Two weeks!

This is a very serious bug.

I've spent yesterday to revert the databases of some customers,

My customers can not stay 2 weeks with out the software!!!

this is not a professional work at all.

it is not a bug which we could live with!!!

As temporary solution we have set Myconnection.Option.Direct to false and copy libmysql.dll into client pc.

New build of MyDAC version 6.10.0.7 has been released. Bug with the "BAD HANDSHAKE" error was fixed in this build.

What about the owners of version 5 or even 4!!

I'm not planning to upgrade to version 6 in the near future!!

The point is that this problem is arised only with latest MySQL server build. With previous MySQL builds MyDAC works without errors. MyDAC version 4 and 5 doesn't support new MySQL server builds.
To solve the problem, you should upgrade to the latest MyDAC build.

What I did to solve this problem, as an emergency action, was simply to uninstall MySQL 5.6 and install MySQL 5.0 instead of upgrading MyDAC. As my application was built some years ago, this solution may seem not so elegant, but it was perfect. It works fine now on Windows 2012 Server Essentials.

The "BAD HANDSHAKE" error can be avoided either by upgrading MyDAC or downgrading MySQL.
Please note that the "BAD HANDSHAKE" error is caused by changes in the MySQL protocol in the latest versions of MySQL. If you want to work with latest MySQL versions, you should use latest MyDAC versions.