Changes in MySQL Connector/ODBC 8.0.28 (2022-01-18, General Availability)

• Deprecation and Removal Notes

• Functionality Added or Changed

• Bugs Fixed

Deprecation and Removal Notes

• The TLSv1 and TLSv1.1 connection protocols were previously deprecated in Connector/ODBC 8.0.26 and support for them is removed starting with this release. Instead, use TLSv1.2 or TLSv1.3.

  The associated NO_TLS_1_0 and NO_TLS_1_1 connection parameters were removed. (WL #14817)

Functionality Added or Changed

• Connector/ODBC can now establish connections using Multi-Factor Authentication (MFA), such that up to three passwords can be specified. The new PASSWORD1, PASSWORD2, and PASSWORD3 connection options are available for specifying the first, second, and third MFA passwords, respectively. The PASSWORD1 option is a synonym for the existing PASSWORD option. In addition, PWD1, PWD2, and PWD3 aliases were added. (WL #14657)

Bugs Fixed

• Microsoft Access could unexpectedly halt when browsing MySQL linked tables when columns in the tables had gaps; and for roughly 100+ record tables as the ODBC driver was incorrectly using memory allocating functions from libmysqlclient. (Bug #33557670, Bug #105503)

• For platforms on which Connector/ODBC utilizes MySQL Server's bundled OpenSSL library (MacOS, Windows, and GenLinux), MySQL Server's linked OpenSSL library was updated to version 1.1.1L. Issues fixed in the new OpenSSL version are described at https://www.openssl.org/news/cl111.txt and https://www.openssl.org/news/vulnerabilities.html. (Bug #33309900)

• SQLColumns() now uses INFORMATION_SCHEMA instead of the deprecated COM_FIELD_LIST by default. COM_FIELD_LIST is only used when NO_I_S is set by Connector/ODBC (which disables INFORMATION_SCHEMA usage). (Bug #29476463, Bug #94235)