Dear MySQL users,
MySQL Server 5.6.46, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.46 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.6, please see
http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html
Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available. This bundle makes it easy
to download and configure a full server and development suite.
The web installer doesn't come bundled with any actual products
and instead relies on download-on-demand to fetch only the
products you choose to install. This makes the initial download
much smaller but increases install time as the individual products
will need to be downloaded.
For information on installing MySQL 5.6.46 on new servers or upgrading
to MySQL 5.6.46 from previous MySQL releases, please see
http://dev.mysql.com/doc/refman/5.6/en/installing.html
MySQL Server 5.6.46, is available in source and binary form for a number of
platforms from our download pages at
http://dev.mysql.com/downloads/mysql
We welcome and appreciate your feedback, bug reports, bug fixes,
patches, etc:
http://bugs.mysql.com/report.php
The following link lists the changes in the MySQL 5.6 since
the release of MySQL 5.6.45. It may also be viewed
online at
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-46.html
Enjoy!
Changes in MySQL 5.6.46 (2019-10-14, General Availability)
Configuration Notes
* It is now possible to compile MySQL 5.6 using OpenSSL
1.1.1, enabling compilation support for MySQL 5.6 against
OpenSSL even when OpenSSL 1.0.2 reaches End of Life
status at the end of 2019.
In addition, MySQL 5.6 now supports TLSv1.1 and TLSv1.2
protocols for encrypted connections. This applies to
MySQL Server, MySQL clients such as mysql and mysqldump,
and master/slave replication. Previously, MySQL 5.6
supported only TLSv1, so TLSv1.1/TLSv1.2 support enables
use of more secure TLS protocols. It also enables
connecting from MySQL 5.6 clients and replication slaves
to MySQL 5.7 and higher servers that have TLSv1 disabled,
which previously was not possible. It also means that
MySQL 5.7 and higher clients that do not want to use
TLSv1 can connect to MySQL 5.6 servers.
* All MySQL 5.6 builds now use OpenSSL. MySQL no longer
supports using yaSSL as the SSL library, and source
distributions no longer include yaSSL.
The WITH_SSL CMake option no longer permits bundled (use
yaSSL) as a valid value, and the default option value has
changed from bundled to system (use the version of
OpenSSL installed on the host system).
Bugs Fixed
* Improper locking during storage engine initialization
could cause a server exit. (Bug #29782379)
* A query with a WHERE clause whose predicate contained a
numeric value in scientific notation was not handled
correctly. (Bug #29723340)
* VS2019 produced compilation errors with debug compilation
selected due to use of the /ZI flag. Now /Z7 is used
instead. (Bug #29691691, Bug #95125)
* Password masking was incomplete for SHOW PROCESSLIST and
some INFORMATION_SCHEMA and Performance Schema tables.
(Bug #20712046)
* The -DWITH_EXAMPLE_STORAGE_ENGINE=1 CMake option was
ignored but should not have been. If
-DWITH_EXAMPLE_STORAGE_ENGINE=0 is given, the EXAMPLE
storage engine is built as a plugin. (Bug #70859, Bug
#17772560, Bug #30133062)
References: See also: Bug #18324650.
On Behalf of MySQL/ORACLE RE Team
Gipson Pulla