How to install MySQL Workbench on mac OS

MySQL Workbench is is a Visual tool developed by Oracle for database architects and developers, it provides data modeling, SQL development, and comprehensive administration tools for server configuration. MySQL Workbench is available on Windows, Linux and Mac OS X .

Why MySQL Workbench

In case you want to use graphic interface rather than just using your Terminal to interact with MySQL server, manipulate your databases and manage your connections in a more structured way, MySQL Workbench is one of the best alternatives. It’s free and available from the official MySQL website and gives developers a complete set of tools to:

  • Create, edit, and run SQL queries.
  • Navigate easily database schemas and objects.
  • Create and edit data.
  • View and export results.

MySQL Workbench features

FeaturesDescription
Automatic SQL code generationMySQL Workbench provides for database designers and architects the capability of transforming easily a visual data model into a physical database with just a few clicks. MySQL Workbench also generates all the SQL code automatically and runs it right the first time, which eliminates the errors possibilities of manually writing complex SQL code.
Easy Database change managementMySQL Workbench includes Schema Synchronization and Comparison utilities that help developers with database change management, maintaining different versions of database schemas and perform synchronization between a model and a live database.
Quick DocumentationIn MySQL workbench all database models can be documented in either HTML or plain text format thanks to its DBDOC tool which reduces the documentation process time-consuming.
Simple Visual SQL EditorThe visual SQL Editor in MySQL Workbench lets developers easily edit data and commit changes using a simple grid format, execute multiple queries simultaneously and view text results, view complete session history of queries and statements via History Panel . Easily retrieve, review, re-run, append or modify previously executed SQL statements. export results data to common formats including CSV, HTML, and XML.
Easy to use Object ManagementFor Object Management MySQL Workbench offers an Object Browser that helps developers to easily navigate, explore, and perform actions on database objects (tables, views, triggers, ..) and an Object Editor for editing, creating or dropping database objects (tables, views, triggers, …)
Helpful Connections ManagementConnections Management Wizard enables developers to create, organize, and manage database connections so advanced users can use the Manage Connections dialog to enter connection parameters like IP address, port, username, and password.
Useful users Administration and server configuration toolsMySQL Workbench offers tools and interfaces to make Users Administration, Server Configuration and Server Connections easy and quick.
Performance improvement
MySQL Workbench provides a Visual Performance Dashboard to improve the performance of MySQL applications and help developers to see where to optimize their SQL queries.
Database Migration SupportMySQL Workbench offer the possibility of migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL so developers and database architects can quickly and easily convert existing applications to run on MySQL and also migrating from earlier versions of MySQL to the latest releases.

Download and install MySQL Workbench on mac OS

To download MySQL Workbench for Mac, go to MySQL website then click DOWNLOADS or you can click directly here download MySQL Workbench, you will see something similar to this:

MySQL downloads page

Now, scroll down  then click on MySQL Community (GPL) Downloads:

MySQL Community Server download

Next, select and click on MySQL Workbench

MySQL Workbench download

After that the following page will appear, now you can select your operating system,  Mac OS, then click Download . Make sure to download the latest version of MySQL Workbench because new releases have more features like Database Migration Support .

MySQL  Workbench download mac OS

To skip the login and sign up step click on No thanks, just start my download And that will start your download.

MySQL Workbench download

When the download is done, open it in Finder and double click the install package that you have just download and start the installation process.

Make sure to drag the MySQL workbench icon to the Applications folder to make it easily accessible from the Applications section.

MySQL Workbench installation


You might be interested in:

How to Install MySQL Server and MySQL Workbench on Windows.

Translate »