MySQL Workbench
MySQL Workbench
8.0.18.CE

4.0

MySQL Workbench free download for Mac

MySQL Workbench

8.0.18.CE
15 October 2019

Efficiently design, manage and document database schemata.

Overview

MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata.

Design

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.

Develop

MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects.

Administer

MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health.

Visual Performance Dashboard

MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. DBAs can quickly view key performance indicators using the Performance Dashboard. Performance Reports provide easy identification and access to IO hotspots, high cost SQL statements, and more. Plus, with 1 click, developers can see where to optimize their query with the improved and easy to use Visual Explain Plan.

Database Migration

MySQL Workbench now provides a complete, easy to use solution for migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL. Developers and DBAs can quickly and easily convert existing applications to run on MySQL both on Windows and other platforms. Migration also supports migrating from earlier versions of MySQL to the latest releases.

It is available as both open source and commercial editions. The Community (OSS) Edition is available from this page under the free software/open source GNU General Public License (commonly known as the "GPL").

What's new in MySQL Workbench

Version 8.0.18.CE:
Functionality Added or Changed:
  • MySQL Workbench now uses C++17.
  • An upgrade of the Scintilla library to the latest version (4.x) resolves a number of display problems observed on macOS Mojave.
  • RapidJSON, which is the parser used by other MySQL products, now replaces the native JSON solution.
  • Casmine, a custom behavior-driven development framework for unit and integration testing of MySQL Workbench code, replaces the TUT unit-test framework.
  • Previously, MySQL Workbench required access to the EPEL repository on enterprise Linux systems, such as Oracle Linux and Red Hat. Access to EPEL is no longer needed by MySQL Workbench for general use, but the repository is still required to use the spatial-data features in MySQL Workbench. The repository can be installed manually, if needed (see Installing Oracle Enterprise Linux and Similar).
Bugs Fixed:
  • An inaccurate text message warned that tables, views, stored procedures, and functions could not be fetched when a MySQL account with limited administrative permissions on the server accessed a valid schema.
  • The visual SQL editor reported a false error on the RENAME COLUMN clause of a valid statement.
  • An error was generated when an attempt was made to add a new account or schema privileges after MySQL Enterprise Firewall was installed and enabled successfully.
  • MySQL Workbench exits unexpectedly during an editing session of trigger code if the focus was shifted away from the Triggers tab and the trigger code contained an error.
  • The Firewall Rules tab was not shown as expected for any user account after the MySQL Enterprise Firewall plugin was installed and enabled successfully. Instead, MySQL Workbench had to be restarted to fully activate the feature when using either a local or remote-management connection.
  • Partition details were not visible within the Partitions tab of Table Inspector when MySQL Workbench (on Windows) was connected to a MySQL server instance running on Linux.
  • Underscore (_) characters in a schema name were converted to the equivalent wildcard characters when schema privileges were applied to a user account in MySQL Workbench.
  • The Ubuntu 19.04 distribution did not include MySQL Workbench support as expected.
  • The reset operation for MySQL Enterprise Firewall rules produced an exception, instead of resetting the rules.
  • The informational message shown when removing MySQL Enterprise Firewall was corrected.
  • A blank MySQL Enterprise Firewall rule could be submitted, which generated an exception.
  • MySQL Enterprise Firewall could not be enabled from MySQL Workbench after it was uninstalled and then reinstalled.
  • Error messages within the Administration - Online Backup tab used incorrect characters to represent versions of MySQL Server.
  • On computers running MacOS, the up and down arrow keys, at times, reversed direction or moved to the next (or previous) query, instead of to the next (or previous) line.
  • Content within the input area of a Query tab did not scroll with the cursor when the cursor was moved beyond the current display range (up or down) using the keyboard on MacOS hosts.
  • Unexpected cursor movement occurred within the query editor when using up and down arrow keys on computers running macOS 10.14 (Mojave).
  • The model icons that represent relationship notations in an EER diagram, as well as the optional grid, were not visible in Dark Mode with macOS.
  • On macOS, the code normally shown with View Source was not visible when Execution Plan was selected from the Result Grid side menu and Dark Mode was set. Similarly, code in the Workbench Scripting Shell was not visible.
  • Connections made to 5.6 and 5.7 server instances used the utf8 character set, instead of utf8mb4.
  • The opening and closing brackets were missing from the Type column output within the Administration - Server Logs tab.
  • On computers running Windows, scrolling up and down with a pointer device was impaired.
  • Test Connection functionality remained enabled for stored connections after they were deleted.
  • On Windows, a query made on a table with exceptionally large column data, such as a BLOB column exceeding 5 MB, caused MySQL Workbench to stop working (client ran out of memory). On restart of the program, a locked file prevented additional queries until the computer was restarted.
  • The PYC file associated with a plugin remained in the modules directory after the plugin was uninstalled.
  • The MySQL Enterprise Firewall plugin was not recognized by MySQL Workbench when MySQL was installed from source.

6 MySQL Workbench Reviews

Rate this app:

pezhman32
19 August 2017

Most helpful

This site is a shit, every stupid person can find the workbench link in mysql website and it requires oracle account, here again I have to create account with giving access to my facebook account but after that it'll redirect me to the original mysql website. totally stupid...
Like (1)
Version 6.3.8.CE
pezhman32
19 August 2017
This site is a shit, every stupid person can find the workbench link in mysql website and it requires oracle account, here again I have to create account with giving access to my facebook account but after that it'll redirect me to the original mysql website. totally stupid...
Like (1)
Version 6.3.8.CE
1 answer(s)
Kris-nx
Kris-nx
15 May 2018
No need to setup an account. Just click the link which say's "No thanks, just start my download" - just tried it and it works.
Like (2)
Agf-
25 April 2015
A great tool so far :-) But now, v6.3.3 crashes after update from 6.2.5 (OS X 10.8.5).
Like
Version 6.3.3
Eric•Woehler
05 December 2013
Seems sluggish under 10.9 Mavericks. Also I see that 6.0.8 is available at dev's web page - but requires Oracle account to login/access/download.
Like
Version 5.2.34
1 answer(s)
Veryvito
Veryvito
10 December 2013
There's actually a small link on the same page labeled "No thanks, just start my download." Clicking this will take you directly to the download link without signing in to Oracle.
Like (2)
Noivad
15 February 2012
I would love this app if it didn’t crash 90%+ of the time I use it. I don’t know what oracle is trying to pull: Are they trying to make it suck so everyone moves to their platform? If so they are doing bang up job. But some of us hobbyists can’t afford Navicat to avoid the crappiness that in MySQL Workbench. I don’t know how someone could report this being stable. Just looking at the bug fix release notes tell you this is Beta level software at best. I just wasted about 30 minutes trying to setup a new connection that works in the command line just fine. MySQL itself is great, and the command line is do-able for me, but when designing complex Schema a Graphic view saves a lot of time, which is why I use it. However is is so flakey, I have to hit cmd-s while putting together schema and testing so often that I feel like I’m on OS 7.0! I usually don’t use such strong language but Workbench pisses me off, it’s a love-hate relationship where Workbench is the psycho-SO. One minute it's working great than the next you lose an hour of productivity.
Like (1)
Version 5.2.34
2 answer(s)
Essadee
Essadee
21 February 2012
I've had zero crashes with it. My only gripe is that it hijacks the text input control keys ctrl-a, ctrl-e, ctrl-h, ctrl-f, ctrl-b, etc.
Like
Noivad
Noivad
10 March 2012
Well, I am up to v5.2.37, and it is more stable now. However it still has problems saving connections which is very frustrating. BTW, v5.2.38 is out now yet MacUpdate still has 5.2.34? Erm… a small blip on an otherwise great site, heh.
Like
Abugirges
08 September 2011
Using Navicat 9 normally. That works but it costly as well. At home I prefer MySQL workbench and I have to say that the GUI is a lot nicer. Stable and efficient. However my demands at home are not that high...
Like (1)
Version 5.2.34
Clarusad
26 November 2009
Is there any PPC version ?
Like
Version 5.2.6
1 answer(s)
SickTeddyBear
SickTeddyBear
05 March 2010
No. The PPC platform is no longer officially supported by MySQL and all development for the platform has stopped.
Like
Version 5.2.16
Free

4.0

App requirements: 
  • Intel 64
  • OS X 10.11.0 or later
Category: 
Developer Website: 
Download(113.1 MB)MacUpdateInstall with MacUpdate

Downloaded & Installed 45,200 times