MySQL Workbench
MySQL Workbench
8.0.19.CE

4.0

MySQL Workbench free download for Mac

MySQL Workbench

8.0.19.CE
13 January 2020

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.19:

Note: Now requires OS X 10.14 or later

Important Note:

MySQL Workbench 8.0.19 is unable to open a new connection to MySQL Server from the home screen if the server is not started and you cannot start a server by using the Workbench Administration feature. Administrative and SQL editing tasks require an online server for the duration of this issue. Feature tasks that you performed with an offline server in previous releases now return an error message indicating that the server is unreachable
This issue is limited to MySQL Workbench 8.0.19. Thank you for your patience
Workaround: Start MySQL Server independently before opening the Administration and SQL Query tabs in

MySQLFunctionality Added or Changed:
  • Workbench. On Linux, you can replace the MySQL Connector/C++ 8.0.19 library with the 8.0.18 library
  • A new context menu item now copies the headers and rows of queried data with tabs as separators, making it convenient to copy and paste query results into Excel. Thanks to Raj Rao for the patch.
  • The following MySQL server language features are now supported: value references in INSERT statements, new options (TLS version, cipher suite, compression, and privilege check) in CHANGE MASTER TO replication statements, random passwords in CREATE USER and ALTER USER statements, EXPLAIN ANALYZE, and binary collation names
  • Context help for the keywords and functions in SQL queries now includes updated syntax and usage information
Bugs Fixed:
  • When attempting to export MySQL 5.7 data using MySQL Workbench 8.0, the server returned an error indicating that INFORMATION_SCHEMA.COLUMN_STATISTICS was an unknown table. Consistent parameter use with mysqldump now skips the table as expected
  • The SQL editor applied syntax-error highlighting to the EXPLAIN keyword in a valid statement prefixed with EXPLAIN ANALYZE, but the statement executed as expected
  • A syntax error was generated for valid ANALYZE TABLE statements with either the UPDATE HISTOGRAM or DROP HISTOGRAM clause
  • Storage engines not supported by MySQL were listed as possible engines that could be selected for tables. Unsupported storage engines now are removed from the suggestion list
  • An existing stored connection could not be replaced with a new connection having the same name when the attempt was made from the Source Selection step of the MySQL Workbench Migration Wizard
  • On macOS, the Cancel and Export buttons in the Export Recordset context window (for SQL INSERT statements) were mostly hidden
  • If the ls command produced an error message together with a list of files, no audit log for the error appeared in the Enterprise MySQL Audit Log Inspector
  • An original SQL Server record (for example, 1020.6) was copied inaccurately to the corresponding MySQL column (1020.0) when migrated using the DECIMAL data type. Similarly, data migrated using the NUMERIC type generated a type-conversion error. Now, both decimal and numeric values are stored as DECIMAL types to fix the resolution of the decimal value or to fix the type conversion. (Bug #30062094, Bug #96230, Bug #30263415, Bug #96744)
  • The uniqueidentifier data type in a SQL Server source table was interpreted during migration as type VARCHAR(64) UNIQUE in the MySQL target column, instead of a VARCHAR column to represent a GUID (UUID) that is not unique
  • The relationship arrows within an EER diagram were not visible when the Dark Mode theme was enabled on a macOS host and the diagram was exported as a single page PDF file. This fix disables the theme in models to prevent conflicts with the colors assigned by the model editor
  • An empty file list was shown when the audit_log_file value was set to any location other than the MySQL server data directory

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

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