Dear MySQL users,
MySQL Connector/ODBC 8.0.22 is a new version in the MySQL Connector/ODBC
8.0 series, the ODBC driver for the MySQL Server.
The available downloads include both a Unicode driver and an ANSI driver
based on the same modern codebase. Please select the driver type you
need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with the latest MySQL server version 8.0.
This release of the MySQL ODBC driver is conforming to the ODBC 3.8
specification. It contains implementations of key 3.8 features,
including self-identification as a ODBC 3.8 driver, streaming of out for
binary types only), and support of the SQL_ATTR_RESET_CONNECTION
connection attribute (for the Unicode driver only).
The release is now available in source and binary form for a number of
platforms from our download pages at
https://dev.mysql.com/downloads/connector/odbc/
For information on installing, please see the documentation at
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation.html
Enjoy and thanks for the support!
============================================================================
Changes in MySQL Connector/ODBC 8.0.22 (2020-10-19, General Availability)
Functionality Added or Changed
* For enhanced security of the existing ENABLE_LOCAL_INFILE
connection string option, the new ENABLE_LOCAL_DIR option
allows restricting LOCAL data loading to files located in
this designated directory. Example usage:
// LOAD LOCAL DATA DIR FROM /tmp
SQLRETURN rc =
SQLDriverConnect(
hdbc1,NULL,
"DSN=myDSN;UID=root;PWD=pwd;DATABASE=test;LOAD_DATA_LOCAL_DIR=/tmp",
SQL_NTS, conn_out, sizeof(conn_out), &conn_out_len,
SQL_DRIVER_NOPROMPT);
// LOAD LOCAL DATA FROM EVERYWHERE
SQLRETURN rc =
SQLDriverConnect(
hdbc1,NULL,
"DSN=myDSN;UID=root;PWD=pwd;DATABASE=test;ENABLE_LOCAL_INFILE=1;",
SQL_NTS, conn_out, sizeof(conn_out), &conn_out_len,
SQL_DRIVER_NOPROMPT);
* Connections made using the MySQL Enterprise Edition SASL
LDAP authentication plugin now are supported on Windows
and Linux, but not on macOS. Connector/ODBC implements
the SCRAM-SHA-1 authentication method of the SASL
authentication protocol.
Bugs Fixed
* Fixed an issue where a parameterized query could cause
memory corruption. (Bug #31678876, Bug #100329)
* Under some circumstances when using server-side prepared
statements, the first row of a multi-row match was not
returned with the result; while it was returned when
using client-side prepared statements instead.
(Bug #31373948, Bug #95423)
* Inserting binary data (BLOBs) using SQLPutData() would
report a syntax error. (Bug #31349038)
On Behalf of MySQL Release Engineering Team,
Kent Boortz