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 .
Related Articles:
- How to Install MySQL Server and MySQL Workbench on Windows.
- Why is Connection Pooling better than Single Connection?.
- How to create MySQL database using node.js.
- Automating Your MySQL Database with Triggers.
- How to use ON DELETE CASCADE in MySQL.
- MySQL + Event Scheduler: How to delete data from MYSQL table using Event Scheduler.
- Using MySQL Event Scheduler: A Complete Guide.
- How to store Session in MySQL Database using express-mysql-session.
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
| Features | Description |
|---|---|
| Automatic SQL code generation | MySQL 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 management | MySQL 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 Documentation | In 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 Editor | The 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 Management | For 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 Management | Connections 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 tools | MySQL 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 Support | MySQL 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:
Now, scroll down then click on MySQL Community (GPL) Downloads:
Next, select and click on MySQL Workbench
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 .
To skip the login and sign up step click on No thanks, just start my download And that will start your 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.
You might also like:
Automating Your MySQL Database with Triggers.
How to use ON DELETE CASCADE in MySQL.
MySQL + Event Scheduler: How to delete data from MYSQL table using Event Scheduler.
Using MySQL Event Scheduler: A Complete Guide.
How to Install MySQL Server and MySQL Workbench on Windows.
ONE-TO-MANY Association in MYSQL Database using Sequelize async/await with Node.js
MANY-TO-MANY Association in MYSQL Database using Sequelize async/await with Node.js.
ONE-TO-ONE Association in MYSQL Database using Sequelize async/await with Node.js.
How to add Routes to insert data into MySQL database-related tables in Node.js API?
Example How to use initialize() Function in Node.js/Express API .
How to use Sequelize async/await to interact with MySQL database in Node.js.
How to interact with MySQL database using async/await promises in node.js ?
How to Build a Complete API for User Login and Authentication using MySQL and Node.js.
Why is Connection Pooling better than Single Connection?.
How to create MySQL database using node.js.
How to store Session in MySQL Database using express-mysql-session.