Active9 months ago
There is a Linux MySQL DB we have connect to. This works fine on Windows 7 computers. Now there is Window 10 an no connection anymore. (Windows XP worked so too)
In this post we will learn how to How To Install MySQL on Windows 10. The same procedure can be used for installing MySQL on Windows 8 / Windows 7. But first let's see What is MySQL. DbExpress driver for MySQL Windows 10 – Provides direct high performance access to MySQL database server. Download dbExpress driver for MySQL for Windows PC from Win10Fix.com. 100% Safe and Secure Free Download (32-bit/64-bit) Latest Version 2019.
Server version: 5.1.73-1 (Debian)
I used the same parameters as on the Windows 7 machines. (ODBC driver 5.1, 32Bit - 'mysql-connector-odbc-noinstall-5.1.13-win32')
- The same driver (I tried version 5.3 32Bit too)
- The same user and password
- the machines are in the same network
The error is 'Malformed package'.
Connecting a Windows DB works.
(The machine may not have an Internet connection.)
Error Messages:
MySQL ODBC 5.1 Driver
Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Connection using old(pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
Altough ist an old server I tried newer drivers:
MySQL 5.3 ANSI Driver
ConnectionFailed
[MySql][ODBC 5.3(a) Driver]Malformed packet:
[MySql][ODBC 5.3(a) Driver]Malformed packet:
MySQL 5.3 Unicode Driver
ConnectionFailed
[MySQL][ODBC 5.3(w) Driver]Malformed packet:
[MySQL][ODBC 5.3(w) Driver]Malformed packet:
MySQL 8.0 ANSI Driver
Download p7zip for Linux (Posix) (x86 binaries and source code): p7zip at SourceForge p7zip is the command line version of 7-Zip for Linux / Unix, made by an independent developer. Super Easy Zip Unzip File Manager, the world's first zip and unzip utility, makes it easy to create, extract, and share zip files on your Android. Zip manager download.
ConnectionFailed
[MySQL][ODBC 8.0(a) Driver]Bad handshake:
[MySQL][ODBC 8.0(a) Driver]Bad handshake:
MySQL 8.0 Unicode Driver
ConnectionFailed
[MySQL][ODBC 8.0(w) Driver]Bad handshake:
[MySQL][ODBC 8.0(w) Driver]Bad handshake:
Download Mysql Odbc Driver For Windows 10
Andy U.
Andy U.Andy U.
1 Answer
It's a driver problem: 5.1.13 does not work, 5.1.12 is needed! Then it works.
Download link:
mysql-connector-odbc-5.1.12-win32.msi
https://dev.mysql.com/downloads/file/?id=411741
mysql-connector-odbc-5.1.12-win32.msi
https://dev.mysql.com/downloads/file/?id=411741
see
MySQL ODBC Link Fails due to 'authentication protocol refused'
MySQL ODBC Link Fails due to 'authentication protocol refused'
Andy U.Andy U.