MySQL Workbench 6.3.10 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.10 as our GA release for
MySQL Workbench 6.3.

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

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

Download MySQL Workbench 6.3.10 GA now, for Windows, macOS 10.11+,
Oracle Linux 7, Fedora 26 and 27, Ubuntu 16.04 and 17.10
or sources, from:

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

Enjoy!

Changes in MySQL Workbench 6.3.10 (2017-11-15)
Bugs Fixed

* Performance information within the Administration –
Dashboard tab demonstrated a slow rate of refresh on
hosts running macOS High Sierra. (Bug #26921498)

* Tooltips within the Administration – Dashboard tab did
not display when the mouse pointer was paused over each
performance graph and the host was running macOS High
Sierra. (Bug #26921467)

* Table objects did not display with the Show Selection
button during the migration process on hosts running
macOS High Sierra. As a result, source objects could not
be selected for inclusion or exclusion. (Bug #26921431)

* Queries executed with the Limit Rows value set to “Don’t
Limit” did not display rows in the result grid on hosts
running macOS High Sierra. (Bug #26921372)

* Executing a query in MySQL Workbench on a host running
macOS High Sierra failed to load the result grid
completely, which prevented result data from appearing
within the Result Grid tab. (Bug #26826418, Bug #87714)

* Performing a keyword search in the EER Diagram Editor on
hosts running macOS High Sierra caused MySQL Workbench to
exit unexpectedly. (Bug #26428849, Bug #87020)

* Forward engineering a physical database design did not
operate as expected on hosts running macOS High Sierra.
(Bug #25979928, Bug #86146)

On Behalf of the MySQL/Oracle Release Engineering Team,
Hery Ramilison

Paramiko 2.x Update Tutorial

MySQL Workbench has tunneling capabilities, and these
depend on third-party libraries.

One required library is Paramiko, which is a python module used to 
create an SSH connection to the destination server. MySQL Workbench uses
Paramiko 1.8.x, and 1.8.x depends on the pycrypto library. But
because recent Python distributions replaced pycrypto with a
different cryptography module, this causes problems for software
(like Workbench) that depends on the older (1.8.x) Paramiko library, 
problems such as MySQL BUG#87381 (http://bugs.mysql.com/bug.php?id=87381).

For details on upgrading the Paramiko library, see our previous blog post
titled
Paramiko Update Tutorial
. The procedure to upgrade to
Paramiko 2.x is the same as described in the tutorial, except 2.x 
requires these additional dependencies: cryptography, bcrypt, and nacl.
These should also be placed next to the paramiko folder as described 
in that tutorial.

We hope this helps!

MySQL Workbench 6.3.9 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.9 as our GA release for
MySQL Workbench 6.3.

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

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

Download MySQL Workbench 6.3.9 GA now, for Windows, Mac OS X 10.10+,
Oracle Linux 7, Fedora 24 and 25, Ubuntu 16.04 and 16.10
or sources, from:

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

MySQL Workbench 6.3.8 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.8 as our GA release for
MySQL Workbench 6.3.

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

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

Download MySQL Workbench 6.3.8 GA now, for Windows, Mac OS X 10.9+,
Oracle Linux 6 and 7, Fedora 23 and Fedora 24, Ubuntu 16.04
or sources, from:

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

MySQL Workbench 6.3.7 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.7 as our GA release for
MySQL Workbench 6.3.

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

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

Download MySQL Workbench 6.3.7 GA now, for Windows, Mac OS X 10.9+,
Oracle Linux 6 and 7, Fedora 23 and Fedora 24, Ubuntu 16.04
or sources, from:

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

MySQL Workbench 6.3.6 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.6 as our GA release for
MySQL Workbench 6.3.

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

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

Download MySQL Workbench 6.3.6 GA now, for Windows, Mac OS X 10.9+,
Oracle Linux 6 and 7, Fedora 22 and Fedora 23, Ubuntu 14.04 and
Ubuntu 15.10 or sources, from:

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

Paramiko Update Tutorial

There are situations when you need to update the python-paramiko library that is bundled with MySQL Workbench. This may be because you prefer using the latest cutting edge versions, are just curious, or you can’t wait for a new Workbench version.

To update, first download the latest python-paramiko release from https://github.com/paramiko/paramiko/releases. After downloading and extracting the archive, you’ll see a paramiko folder inside of the extracted folder. This folder needs to be copied into the appropriate MySQL Workbench folder on the system.

* For Windows, this location is usually
WB_INSTALLDIR/python/site-packages/paramiko

* For OS X, this will be
/Applications/MySQLWorkbench.app/Contents/Resources/Libraries/paramiko

* For Linux, you should use your repository manager (yum, apt-get, etc.), but if it doesn’t have the latest paramiko version then you
should first uninstall your old version, download the latest paramiko, cd into the paramiko directory, and then execute “sudo python setup.py
install” to install system wide paramiko.

Note: since Paramiko 1.12, to use it, you also need the ecdsa package which can be downloaded from here:
https://github.com/warner/python-ecdsa/releases.
The same method applies; download and extract the contents of the archive, and you’ll see a ecdsa folder that should be placed next to the paramiko folder.

Please keep in mind that switching paramiko this way can break MySQL Workbench, so always make a backup first.

MySQL Workbench 6.1.3 RC has been released

The MySQL developer tools team announces 6.1.3 RC – the final release candidate for MySQL Workbench 6.1.

MySQL Workbench 6.1 is the upcoming major update for the official MySQL graphical development tool.
Introducing over 30 new features, this version has many significant enhancement focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You’ll see this in additions to the SQL Editor as well as new dashboard visualization and reporting that takes 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.3 RC now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 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

MySQL Workbench on Ubuntu 11.10

We have seen many reports about broken build and freezes which are experienced on Ubuntu 11.10. While the build fix was pretty simple, the freezes took us a bit more time to hunt them down.

The point is that MySQL Workbench relies on glib’s idle signals which are emitted when Gtk’s main event loop has nothing to do. In Ubuntu 11.10, for some reason, for certain types of windows we use, these idle signals are not emitted cause window drawing code constantly reschedules idle redraws.

The bug report which is related to the freezes and compilation problems is at http://bugs.mysql.com/62347

Here is a link to the patch: is http://bugs.mysql.com/file.php?id=17639

Quick help for an upgrade problem

With the just released version 5.2.34 we also changed the python version used in MySQL Workbench (to 2.7). However, this produces a problem when upgrading from 5.2.33. The reason is that the installer leaves all the compiled python files (*.pyc) in the installation folder. On next load of Workbench you can’t even get beyond the splash screen.

We will soon publish a new release with that problem fixed. In the mean time simply uninstall Workbench before you install 5.2.34. Your stored connections, starters, settings etc. are not touched by this. Make sure that you remove any remaining file once uninstallation finished, before you install 5.2.34.

This problem was first encountered on Windows using the msi package, but might also affect the zip package or even other platforms. In any case remove the old files before installing 5.2.34.