MySQL Workbench
MySQL Workbench
8.0.21.CE

4.0

MySQL Workbench free download for Mac

MySQL Workbench

15 July 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.21:
Functionality Added or Changed:
  • A new check box was added to the dialog for resetting an expired password. When selected it indicates that the server version in use precedes MySQL 5.7
MySQL Workbench now supports the following MySQL 8.0.19 and 8.0.20 server language features:
  • DROP CHECK, ALTER CONSTRAINT, and DROP CONSTRAINT in ALTER TABLE statements
  • Locking clause for query expressions
  • Table values constructor
  • Short table select syntax
  • New requirements for the CHANGE MASTER replication statement (row format, primary key check)
  • Failed login attempts and password lock time in ALTER USER statements
  • Format support for EXPLAIN ANALYZE statements
New and changed keywords:
  • ARRAY
  • FAILED_LOGIN_ATTEMPTS
  • MASTER_COMPRESSION_ALGORITHM
  • MASTER_TLS_CIPHERSUITES
  • MASTER_ZSTD_COMPRESSION_LEVEL
  • MEMBER
  • OFF
  • PASSWORD_LOCK_TIME
  • PRIVILEGE_CHECKS_USER
  • RANDOM
  • REQUIRE_ROW_FORMAT
  • REQUIRE_TABLE_PRIMARY_KEY_CHECK
  • STREAM
  • TIMESTAMP
  • TIME
Bugs Fixed:
  • MySQL Workbench Migration Wizard encountered type -154 (SQL_SS_TIME2) while copying Microsoft SQL Server tables, and it returned an error on the unhandled type. This fix adds the following new SQL data types to the wizard: SQL_SS_TIME2 (supported by MySQL) and SQL_SS_TIMESTAMPOFFSET (not supported)
  • The TableRead, TableInsert, TableUpdate, and TableDelete events for each table touched by a query did not include complete information in the Audit Inspector
  • Valid TABLE and VALUES statements were identified as having syntax errors in the SQL editor
  • MySQL accounts created during the prerequisite setup using the Create MEB Account button were not granted sufficient privilege to schedule an online backup or to execute a full backup on Windows
  • The Table Data Import Wizard returned an error when used to import a large JSON file, rather than loading the file
  • Text selected in the SQL editor was blocked by the highlight color
  • A change made to the CREATE statement to rename an existing stored procedure did not revise the corresponding name in the generated DROP PROCEDURE statement when the change was applied using the editor. This fix modifies the generated statement to no longer drop the original stored procedure after it is renamed
  • On Windows, statements that do not generate a result set, such as INSERT or UPDATE statements, caused MySQL Workbench to close unexpectedly after the EXPLAIN operation was executed and then the Result Grid output type was selected
  • Although the installation and file path were valid, MySQL Workbench did not find the ogr2ogr and ogrinfo files when loading spatial data
  • A column created with NULL ON UPDATE CURRENT_TIMESTAMP(6) prevented the MySQL Table Editor from showing table information, such as indexes, views, foreign keys, and so on
  • Memory use on a Windows host was excessive when a large result set was exported to a file, causing MySQL Workbench to become unresponsive
  • Synchronizing a database that included a table with JSON fields to the data model produced new, separate tables for the JSON data, instead of updating the original table. In this instance, the target MySQL version set in the modeling preference, 5.6.30 by default, does not support the operation. This fix sets the default version to MySQL 8.0, but the value can be adjusted by selecting Preferences, Modeling, and then MySQL from the Edit menu
  • The zoom-out button did not alter the zoom level of spatial data when viewed from a Linux host, unless the zoom level was reset to the outermost level first
  • MySQL Workbench became unresponsive for several minutes after a server startup attempt was made on macOS hosts
  • No errors or warnings were reported when scheduling a backup with MySQL Enterprise Backup, although the backup did not execute as scheduled
  • A Sybase database migration with the ODBC (FreeTDS) connection method produced an exception when the connection was tested
  • MySQL Workbench server administration could not acquire management access to Oracle Solaris. For a list of supported platforms, visit https://www.mysql.com/support/supportedplatforms/workbench.html
  • On Linux, edits made to values in the result grid were lost when using the pointer device to move within the grid, rather than pressing the Enter or Tab key to change the focus
  • Forward engineering a valid MySQL Workbench model was unsuccessful when the operation was performed using a MySQL 5.5 server instance
  • On macOS, a query containing SELECT @@hostname returned the column header, but the query did not show any visible output unless the first row below the column header was selected
  • After reverting changes made to triggers in a schema that had been saved and synchronized, MySQL Workbench was not able to locate any differences when the reverted schema was re-synchronized with the model
  • A connection saved with MySQL Workbench Migration Wizard was no longer visible in the wizard after MySQL Workbench was upgraded to a later version. An attempt to save the connection again, using the same name, returned an error indicating that the original connection was preserved
  • No connection could be made to the PostgreSQL database system when it was selected as the source in MySQL Workbench Migration Wizard on macOS
MySQL Workbench for Mac Old Versions

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate MySQL Workbench app?

6 Reviews of MySQL Workbench

pezhman32
19 August 2017
Version: 6.3.8.CE

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...
(1)
pezhman32
19 August 2017
Version: 6.3.8.CE
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...
(1)
Show comment (1)
4
Agf-
25 April 2015
Version: 6.3.3
A great tool so far :-) But now, v6.3.3 crashes after update from 6.2.5 (OS X 10.8.5).
(0)
3
Eric•Woehler
05 December 2013
Version: 5.2.34
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.
(0)
Show comment (1)
2
Noivad
15 February 2012
Version: 5.2.34
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.
(1)
Show comments (2)
4
Abugirges
08 September 2011
Version: 5.2.34
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...
(1)
Clarusad
26 November 2009
Version: 5.2.6
Is there any PPC version ?
(0)
Show comment (1)
Free

4.0

App requirements: 
  • Intel 64
  • macOS 10.14.0 or later
License: 
FreeAbsolutely Free

Downloaded & Installed 46,428 times

Similar apps
Navicat for MySQL
Navicat for MySQL
Graphically manage MySQL databases.
Is this app is similar to Navicat for MySQL? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
SQLPro for MySQL
SQLPro for MySQL
Database management studio for MySQL.
Is this app is similar to SQLPro for MySQL? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
Valentina Studio
Valentina Studio
Free database manager for many databases.
Is this app is similar to Valentina Studio? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
Navicat Essentials for MySQL
Navicat Essentials for MySQL
Simple graphical frontend for MySQL databases.
Is this app is similar to Navicat Essentials for MySQL? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
Querious
Querious
MySQL database management application.
Is this app is similar to Querious? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes