Error MySQL 5.5.12

cybsistemas · Post by **cybsistemas** » Sat 07 May 2011 19:13

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

Dimon · Post by **Dimon** » Tue 10 May 2011 08:25

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

kallenos · Post by **kallenos** » Tue 10 May 2011 10:05

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

cybsistemas · Post by **cybsistemas** » Tue 10 May 2011 11:01

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)

Dimon · Post by **Dimon** » Wed 11 May 2011 09:36

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

[email protected] · Post by **[email protected]** » Wed 11 May 2011 11:37

When can we expect the latest MyDAC build?

Dimon · Post by **Dimon** » Wed 11 May 2011 11:44

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

gemal · Post by **gemal** » Wed 11 May 2011 15:03

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

Argh!!! Two weeks!

This is a very serious bug.

kallenos · Post by **kallenos** » Thu 12 May 2011 06:22

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!!!

lgts · Post by **lgts** » Thu 12 May 2011 09:31

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

Dimon · Post by **Dimon** » Thu 12 May 2011 10:13

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

kallenos · Post by **kallenos** » Thu 12 May 2011 12:02

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

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

Dimon · Post by **Dimon** » Thu 12 May 2011 12:58

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.

josias · Post by **josias** » Mon 14 Oct 2013 23:39

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.

AndreyZ · Post by **AndreyZ** » Tue 15 Oct 2013 09:12

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.

Devart Forums

Error MySQL 5.5.12

Error MySQL 5.5.12

Same Problem #08S01 Bad handshake with MYSQL 5.5.12

2 weeks!!!

Error MySQL 5.5.12

What about older MyDac Versions?

Re: Error MySQL 5.5.12

Re: Error MySQL 5.5.12