MySQL Workbench 6.1.7 GA has been released

[Vishal Chaudhary]

Dear MySQL users,

The MySQL Workbench team announces availability of version 6.1.7 of its
flagship product. MySQL Workbench 6.1.7 is a periodic maintenance release
including 17 bug fixes. Additionally, the supported Linux distribution list has been
refreshed. Users of the product are recommended to upgrade to this version.

MySQL Workbench 6.1

With over 30 new features, this version has many significant
enhancements focusing on real-time performance assessment and analysis
from the SQL statement level to server internals and file IO. You can
see this from additions to the SQL Editor as well as new dashboard
visualization and reporting that take advantage of MySQL Server 5.6
and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 is leveraging work from various teammates in
MySQL Engineering by introducing a schema called "SYS" that provides
simplified views on Performance Schema, Information Schema, and other
areas.
Special thanks to the server optimizer team, server runtime team, and Mark
Leith.  For Oracle DBAs MySQL SYS is similar to the V$ catalog views, and
MSSQL folks its like DMVs (Dynamic Management Views).

MySQL Workbench 6.1 includes:

* Improved drag and drop support in the Home screen and SQL Editor
* Visual Explain 2. The Visual Explain feature was revamped and is now
easier to read and interpret. You can also get the traditional tabular
explain output from within the same interface.
* Performance Dashboard. A graphical representation of some key statistics
from the server status, gives you a bird's eye view of the status of key
server subsystems.
* For advanced users, Performance Schema Instrumentation. A GUI for
configuring the Performance Schema in detail, for advanced users.
* Performance Schema based reporting. Gives insight into the operation
of the server through many high-level reports.
* New query result view. Get more information about queries you execute,
such as information about the fields in your result set and key performance
statistics from your query (timing, index usage, number of rows scanned,
joins etc).
* Form Editor for resultsets. In addition to the result grid, you can now
edit records row by row in a form style editor.
* Table Inspector. Similar to the Schema Inspector, view detailed
information from tables. A streamlined interface for creating indexes is
also included.
* Support for the Windows accessibility API and Windows high contrast
color schemes. A new high contrast theme has been introduced.
* And more.

More than 60 enhancement requests and bugs reported by users have also been
addressed, providing performance, usability and stability improvements
across the board.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.1.7 now, for Windows, Mac OS X 10.6+, Oracle
Linux 6, Fedora 20, Ubuntu 12.04 and Ubuntu 14.04 or sources,
from:

http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update
MySQL Workbench and other MySQL products.

Quick links:
-http://mysqlworkbench.org/
- Download:http://dev.mysql.com/downloads/tools/workbench/
- Bugs:http://bugs.mysql.com
- Forums:http://forums.mysql.com/index.php?151

Enjoy!

Changes in MySQL Workbench 6.1.7 (2014-06-27)

   Bugs Fixed

     * Security Fix: The linked OpenSSL library for MySQL Workbench
       Commercial 6.1.7 has been updated from version 1.0.1g to
       version 1.0.1h. Versions of OpenSSL prior to and including
       1.0.1g are reported to be vulnerable to CVE-2014-0224
(http://www.cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-02
       24).
       This change does not affect the Oracle-produced MySQL
       Community build of MySQL Workbench 6.1.7, which uses the yaSSL
       library instead. (CVE-2014-0224)

     * Under certain conditions (with a subquery), Visual Explain
       would fail with the error "error calling Python module
       function SQLIDEQueryAnalysis.visualExplain", even when the
       tabular EXPLAIN was properly generated. (Bug #18997475, Bug
       #72725)

     * The Backup Recovery process could fail and generate an
       unhandled exception titled "list indices must be integers, not
       NoneType" after clicking Cancel. General improvements were
       made to this functionality. (Bug #18925451)

     * The Form Editor could generate an "Index was out of range"
       error after adding a new record and then clicking Add Record.
       (Bug #18891983, Bug #72844)

     * The schema selection step of the migration wizard would not
       display the complete names of the schemas nor complete the
       migration process if the schema name contained a dot. (Bug
       #18844624, Bug #72757)

     * Sometimes MySQL Workbench would crash when connecting to a
       remote Linux host using SSH. (Bug #18817608, Bug #72486)

     * The Backup Restore action would hang with a MySQL server
       running in a MySQL Sandbox environment that used MySQL Sandbox
       to start/stop the MySQL server. (Bug #18814560)

     * On Ubuntu 14, the dependency check was updated to allow any of
       mysql-client, mysql-client-5.6 or mysql-community-client
       client libraries. Previously, the dependency check could fail.
       (Bug #18841046, Bug #72729)

     * With the Move Model tool enabled, dragging a model while
       hovering (and pausing) over a table would generate a tooltip
       that would not go away. (Bug #18718801, Bug #72555)

     * Executing the following steps (in order) would generate an
       error: change layer name, change layer color, and then resize
       layer. (Bug #18760955, Bug #72647)

     * For a new EER diagram, editing a text object after adding a
       different text object could cause MySQL Workbench to crash.
       A workaround was to close the new diagram and model, and then
       reopen the model and diagram. (Bug #18718784, Bug #72559)

     * MySQL error code 1698 (ER_ACCESS_DENIED_NO_PASSWORD_ERROR) is
       now handled as an authentication error. (Bug #18711142, Bug
       #72536)

     * After enabling Import from Folder in the Data Import / Restore
       wizard for a connection, doing the same for a second
       connection would reset (deselect) this option in the first
       connection. (Bug #18685308, Bug #72492)

     * A new "Override sudo command line" option was added to the
       connection manager under the System Profile in the connection
       editor for systems other than Windows. It can (optionally)
       configure the sudo command line to use on any operation
       requiring root access for administration tasks.
       If left blank (the default), MySQL Workbench continue to pass
       in -S and -p. Otherwise, you can replace the default sudo
       command. This should only be defined if the server
       configuration requires it. (Bug #18679748)

     * For Linux, Ubuntu 14.04 builds now exist. (Bug #18622692, Bug
       #72388)

     * On Mac OS X, pressing Option + Shift with the Arrow buttons
       did not function as expected in the SQL editor. This key
       combination selects adds a word (string) to the current
       selection. (Bug #18385643, Bug #72014)

     * When creating a table, the FULLTEXT and SPATIAL index types
       were not present in the index type drop-down list when
       non-MyISAM tables were selected. (Bug #18376840, Bug #71998)

On behalf of the MySQL Workbench and the MySQL/ORACLE RE Team.
Vishal Chaudhary