#645 MySQL 8.0.44 error connecting bad handshake. Code: 1043

[Andre Camargo Pacheco]

The complete error is: SQL Error: Bad handshake
Code: 1043 Message: Connect to "" as user "root".

My environment is Win11, Delphi 13, MySQL 8.0.44, Zeos 8.0.1-beta, 32-bit project, using the MySQL5 32-bit DLL, user root already as mysql_native_password.

It seems to be a problem with Delphi 13 and Zeos 8.0.1-beta because if I use an executable made in Delphi 11 with Zeos 7.X in the same environment mentioned above, the connection is made successfully without problems.

Furthermore, the FireDAC FDConnection connects normally. To test this, I created a new test project, added Zeos and FireDAC, and Zeos gives the error above, while FireDAC connects normally. This leads me to believe that everything is correct regarding the DLL, MySQL, and Delphi 13, except for the combination of Delphi 13 with Zeos 8.0.1-beta.

Attached is a screenshot of the Zeos and FireDAC object inspector.

[marsupilami79]

Closed, because it is a duplicate of [#646]