imported>Moretti: +data from wikidata

2024-12-04T14:58:31Z

+data from wikidata

New page

{{Short description|Database design graphical tool}}
{{Use American English|date=January 2019}}
{{Primary sources|date=January 2010}}
{{Use mdy dates|date=April 2021}}
{{Infobox software
| screenshot = The MySQL Workbench startup screen.png
| caption = The home screen
| developer = [[Oracle Corporation]]
| latest release version = {{wikidata|property|references|preferred|edit|P348|P548=Q2804309}}
| latest release date = {{Start date and age|{{wikidata|qualifier|preferred|single|P348|P548=Q2804309|P577}}}}
| repo = https://github.com/mysql/mysql-workbench
| programming language = [[C++]], [[C (programming language)|C]], [[Python (language)|Python]]
| operating system = [[Windows]], [[OS X]] and [[Linux]]<ref name=kros-platform>{{cite book |chapter-url=http://dev.mysql.com/doc/workbench/en/wb-installing.html |chapter=Chapter 2: Installation |url=http://dev.mysql.com/doc/workbench/en/index.html |title=MySQL Workbench |date=2014-11-27 |publisher=[[MySQL]] }}</ref>
| genre =
| license = {{Plainlist|
* Community ed.: [[GNU General Public License|GPL]]
* Standard ed.: [[Commercial software|Commercial]] [[proprietary software]]
}}
}}
'''MySQL Workbench''' is a visual [[database design]] tool that integrates [[SQL]] [[Software development|development]], [[Database administration|administration]], [[database design]], creation and maintenance into a single [[integrated development environment]] for the [[MySQL]] database system. It is the successor to DBDesigner 4 from fabFORCE.net, and replaces the previous package of software, [[#MySQL GUI Tools Bundle|MySQL GUI Tools Bundle]].

==History==

===fabFORCE.net DBDesigner4===
[[File:Dbd4 ss simplemodel.png|thumb|fabFORCE.net DBDesigner4]]
'''DBDesigner4''' is an open source visual database design and querying tool for the MySQL database released under the [[GNU General Public License|GPL]].<ref>[http://www.fabforce.net/dbdesigner4/ DBDesigner4 Webpage], fabFORCE.net. Retrieved 2010-03-26.</ref> It was written in 2002/2003 by the [[Austria]]n programmer Michael G. Zinner for his fabFORCE.net platform using Delphi 7 / Kylix 3.<ref>[http://www.fabforce.net/about.php fabFORCE.net About Page], fabFORCE.net. Retrieved 2010-03-26.</ref><ref>[http://www.fabforce.net/downloadfile.php?iddownloadfile=7 DBDesigner4 Source Code Download], fabFORCE.net. Retrieved 2010-03-26.</ref>

While being a physical-modeling only tool DBDesigner4 offers a comprehensive feature set including reverse engineering of MySQL databases, model-to-database synchronization, model poster printing, basic version control of schema models and a SQL query builder.<ref>[http://www.fabforce.net/dbdesigner4/features.php DBDesigner4 Feature List], fabFORCE.net. Retrieved 2010-03-26.</ref> It is available for MS Windows, Mac OS X and Linux.<ref>[http://www.fabforce.net/downloads.php DBDesigner4 Download Page], fabFORCE.net. Retrieved 2010-03-26.</ref>

In late 2003, Zinner was approached by representatives from MySQL AB and joined the company to take over the development of graphical user interface (GUI) tools for MySQL. This led to the creation of the MySQL GUI Tools Bundle.<ref>Arjen Lentz, [http://dev.mysql.com/tech-resources/interviews/mike-zinner.html "Interview with Michael G. Zinner"] {{webarchive|url=https://web.archive.org/web/20100503235228/http://dev.mysql.com/tech-resources/interviews/mike-zinner.html |date=May 3, 2010 }}, MySQL.com. Retrieved 2010-03-26.</ref>

===MySQL GUI Tools Bundle===
[[File:MySQLadministrator1.png|thumb|The MySQL Administrator part of GUI Tools]]
The '''MySQL GUI Tools Bundle''' is a cross-platform open source suite of desktop applications for the administration of MySQL database servers, and for building and manipulating the data within MySQL databases. It was developed by MySQL AB and later by [[Sun Microsystems]] and released under the GPL. Development on the GUI Tools bundle has stopped, and is now{{when|date=April 2014}} only preserved under the Download Archives of the MySQL site.<ref>[http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle: Archived Downloads], MySQL.com, Retrieved 2010-03-26.</ref>

The GUI Tools bundle has been superseded by MySQL Workbench, and reached its End-of-Life with the beta releases of MySQL Workbench 5.2. However, the MySQL Support team continued to provide assistance for the bundle until June 30, 2010.<ref>[http://dev.mysql.com/support/eol-notice.html MySQL Product Support EOL Announcements], MySQL.com, Retrieved 2010-03-26.</ref>

==Releases==
The first preview version of MySQL Workbench was released in September 2005,<ref>[http://forums.mysql.com/read.php?3,146587,146587#msg-146587 MySQL GUI Bundle announcement (without MySQL Workbench)], MySQL.com Forum Archive, Retrieved 2010-03-26.</ref> and was not included in the [[#MySQL GUI Tools Bundle|MySQL GUI Tools Bundle]]. Development was started again in 2007 and MySQL Workbench was set to become the MySQL GUI flagship product.<ref>[http://forums.mysql.com/read.php?113,142329,142329#msg-142329 Workbench Schedule Announcement], MySQL.com Forum Archive, Retrieved 2010-03-26.</ref>

Version numbering was started at 5.0 to emphasise that MySQL Workbench was developed as the successor to DBDesigner4.<ref>[http://wb.mysql.com/?page_id=28 MySQL Workbench FAQ - General], MySQL Workbench Blog, Retrieved 2010-03-26.</ref>

===MySQL Workbench 5.0 and 5.1===
MySQL Workbench 5.0 and 5.1 are specialized visual [[database design]] tools for the MySQL database. While MySQL Workbench 5.0 was a MS Windows-only product, cross-platform support was added to MySQL Workbench 5.1 and later.<ref>Michael G. Zinner, [http://wb.mysql.com/?p=19 "Why Release on Windows First"], MySQL Workbench Blog, Retrieved 2010-03-26.</ref><ref>[http://wb.mysql.com/?page_id=49 MySQL Workbench Releases], MySQL Workbench Blog, Retrieved 2010-03-26.</ref>

===MySQL Workbench 5.2===
Starting with MySQL Workbench 5.2 the application has evolved to a general database GUI application. Apart from physical database modeling it features an SQL Editor, database migration tools, and a database server administration interface, replacing the old MySQL GUI Tools Bundle.

===MySQL Workbench 6.0===
On May 22, 2013, the MySQL Workbench Team announced<ref>{{cite web|url=http://mysqlworkbench.org/2013/05/mysql-workbench-6-0-%E2%80%93-a-sneak-preview/|title=MySQL Workbench 6.2 » Blog Archive » MySQL Workbench 6.0 – A Sneak Preview|work=mysqlworkbench.org|access-date=May 10, 2015}}</ref> that they were working on Version 6.0. The first public beta, labeled version 6.0.2, was released<ref>{{cite web|url=http://lists.mysql.com/announce/840|title=MySQL Lists: announce: MySQL Workbench 6.0.2 Beta 1 released|work=mysql.com|access-date=May 10, 2015}}</ref> on June 14, 2013, and the first general-availability release was made on August 12, 2013.<ref name=oracle-website-release>{{cite web|title=Changes in MySQL Workbench 6.0|url=http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-0.html|work=MySQL|publisher=Oracle Corporation|access-date=20 August 2013}}</ref>

===MySQL Workbench 6.1===
On January 23, 2014 the MySQL Workbench Team announced<ref>{{cite web|url=http://mysqlworkbench.org/2014/01/mysql-workbench-6-1-1-beta-has-been-released/|title=MySQL Workbench 6.2 » Blog Archive » MySQL Workbench 6.1.1 BETA has been released|work=mysqlworkbench.org|access-date=May 10, 2015}}</ref> its first public beta release of Version 6.1. The first general-availability release was made on March 31, 2014.<ref name=oracle-website-release-6-1>{{cite web|title=Changes in MySQL Workbench 6.1|url=http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html|work=MySQL|publisher=Oracle Corporation|access-date=2 June 2014}}</ref> New features include improved Visual Explain output, a Performance dashboard, Performance Schema support, additional query result views, and [[Microsoft Active Accessibility|MSAA]] support.

===MySQL Workbench 6.2===
On August 19, 2014, the MySQL Workbench Team announced<ref>{{cite web|url=http://mysqlworkbench.org/2014/08/mysql-workbench-6-2-1-beta-has-been-released/|title=MySQL Workbench 6.2 » Blog Archive » MySQL Workbench 6.2.1 BETA has been released|work=mysqlworkbench.org|access-date=May 10, 2015}}</ref> its first public beta release of Version 6.2. The first general-availability release was made on September 23, 2014.<ref name=oracle-website-release-6-2>{{cite web|title=Changes in MySQL Workbench 6.2|url=http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-2.html|work=MySQL|publisher=Oracle Corporation|access-date=3 October 2014}}</ref> New features are shortcut buttons for common operations, "pinning" of the results tab, Microsoft Access Migration,<ref>{{cite web|url=http://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html|title=MySQL :: MySQL Workbench :: 10.4 Microsoft Access Migration|work=mysql.com|access-date=May 10, 2015}}</ref> MySQL Fabric Integration, Spatial View Panel to visualize [[Spatial database|spatial]] and [[geometry]] data, Geometry Data Viewer, Result Set Width, SQL editor tabs are properly saved, Shared Snippets, a new Run SQL Script dialog, Model Script Attachments, Client Connections management has a new "Show Details" window where more information about connections, locks, and attributes is displayed, performance columns can display sizes in [[Kilobyte|KB]], [[Megabyte|MB]], or [[Gigabyte|GB]], the migration wizard can resume operations of data copying if interrupted, MySQL connection password is remembered across the MySQL Workbench session.

===MySQL Workbench 6.3===
On March 5, 2015, the MySQL Workbench Team announced<ref>{{Cite web|url=http://mysqlworkbench.org/2015/03/mysql-workbench-6-3-1-beta-has-been-released/|title=MySQL Workbench 6.3.1 Beta has been released}}</ref> its first public beta release of Version 6.3. The first general-availability release was made on April 23, 2015.<ref name=oracle-website-release-6-3>{{cite web|title=Changes in MySQL Workbench 6.3|url=http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html|publisher=Oracle Corporation}}</ref> New features include a "fast migration" option to migrate the data from the command-line instead of the GUI, a SSL certificate generator, improved SQL auto-completion, a new table data import and export wizard, and MySQL Enterprise Firewall support. Version 6.3.8, MySQL Workbench for MacOS has incompatibilities with MacOS Sierra.<ref>{{Cite web|url=https://stackoverflow.com/questions/39982373/mysql-compatibility-with-macos-sierra|title=MySQL Compatibility with MacOS Sierra|website=Stack Overflow}}</ref> Version 6.3.9 is compatible with MacOS Sierra, however it doesn't work on MacOS High Sierra.<ref name=high_sierra>{{Cite web|url=https://bugs.mysql.com/bug.php?id=87862|title=MySQL Bugs: #87862: MySQL does not work on MacOS High Sierra|website=bugs.mysql.com}}</ref> MacOS High Sierra users need to run version 6.3.10.<ref name=high_sierra/>

===MySQL Workbench 8.0===
On April 5, 2018, the MySQL Workbench Team announced<ref>{{Cite web|url=https://mysqlworkbench.org/2018/04/mysql-workbench-8-0-11-rc-has-been-released/|title=MySQL Workbench 8.0.11-rc has been released}}</ref> the first public release of version 8.0.11 as a Release Candidate (RC) together with MySQL Community Server 8.0.11. The first General Availability (GA) release appeared on July 27, 2018<ref>{{Cite web|url=https://mysqlworkbench.org/2018/07/mysql-workbench-8-0-12-has-been-released/|title=MySQL Workbench 8.0.12 has been released}}</ref> again together with the server following the new policy for aligning version numbers across most of MySQL products.<ref>{{Cite web|url=https://mysqlrelease.com/2018/03/mysql-8-0-it-goes-to-11/|title=MySQL 8.0: It Goes to 11!}}</ref> MySQL Workbench now uses [https://github.com/antlr/antlr4 ANTLR4] as backend parser and has a new auto-completion engine that works with object editors (triggers, views, stored procedures, and functions) in the visual SQL editor and in models. The new versions add support for new language features in MySQL 8.0, such as common-table expressions and roles. There's also support for invisible indexes and persisting of global system variables. The new default authentication plugin <code>caching_sha2_password</code> in MySQL 8.0 is now supported by Workbench, so resetting user accounts to other authentication types is no longer necessary when connecting to the latest servers. Administrative tabs are updated with the latest configuration options and the user interface was made more consistent between the tabs.

As of 1 July 2024, the latest version is 8.0.38, but its syntax-checker is inconsistent with deprecation of the terms "master" and "slave" in favour of "source" and "replica" respectively in MySQL version 8.0.

==Features==
Prominent features of MySQL Workbench are:
* General
** Database Connection & Instance Management
** Wizard driven action items
** Fully scriptable with [[Python (programming language)|Python]] and [[Lua (programming language)|Lua]]
** Support for custom plugins
** MSAA (Windows Accessibility API) compliant
** Supports MySQL Enterprise features (Audit Log, Firewall, and Enterprise Backup)
* SQL Editor
** Schema object browsing, inspection, and search
** SQL syntax highlighter and statement parser
** SQL code completion and context sensitive help
** Multiple and editable result sets
** Visual EXPLAIN
** SQL snippets collections
** SSH connection tunneling
** Unicode support
* Data modeling
** ER diagramming
** Drag'n'Drop visual modeling
** Reverse engineering from SQL Scripts and live database
** Forward engineering to SQL Scripts and live database
** Schema synchronization
** Printing of models
** Import from fabFORCE.net DBDesigner4
* Database administration
** Start and stop of database instances
** Instance configuration
** Database account management
** Instance variables browsing
** Log file browsing
** Data dump export/import
* Performance monitoring
** Performance Schema metrics
** MySQL instance dashboard
** Query statistics
* Database migration
** Any ODBC compliant database
** Native support: Microsoft SQL Server, PostgreSQL, SQL Anywhere, SQLite, and Sybase ASE

==Licensing and editions==
MySQL Workbench is the first MySQL family of products that offer two different editions - an open source and a proprietary edition.<ref>[http://dev.mysql.com/workbench/?page_id=11 MySQL Workbench Editions], MySQL Workbench Blog. Retrieved 2010-03-26.</ref> The "Community Edition" is a full featured product that is not crippled in any way. Being the foundation for all other editions it will benefit from all future development efforts. The proprietary "Standard Edition" extends the Community Edition with a series of modules and plugins.<ref>Michael G. Zinner, [http://lists.mysql.com/gui-tools/2022 "Beta testers wanted!"], MySQL Mailing List Archives, 2007-11-19. Retrieved 2010-03-26.</ref>{{Citation needed|reason=While this has apparently been the case in 2007, some reference showing that the situation persists should be found.|date=July 2012}}

As this business decision was announced soon after the takeover of MySQL by Sun Microsystems, this has caused speculation in the press about the future licensing of the MySQL database.<ref>[http://www.oreillynet.com/conferences/blog/2008/04/news_release_sun_introduces_my.html Sun Introduces MySQL Workbench], O'Reilly Conference News, Retrieved 2010-03-26.</ref><ref>Sean Michael Kerner, [http://www.internetnews.com/dev-news/article.php/3741616/MySQL+Not+Going+Closed+Source.htm "MySQL Not Going Closed Source?"], internetnews.com. Retrieved 2010-03-26.</ref>

==Community reception and reviews==
Since its introduction MySQL Workbench has become popular within the MySQL community. It is now the second most downloaded product from the MySQL website with more than 250,000 downloads a month.<ref>[http://wb.mysql.com/?page_id=17 MySQL Workbench Contribute Page], MySQL Workbench Blog. Retrieved 2010-03-26.</ref> Before that it was voted Database Tool of the Year 2009 on Developer.com.<ref>[http://www.developer.com/java/other/article.php/3795991/Winners-of-the-Developercom-Product-of-the-Year-2009-Are-Announced.htm Winners - Product of the Year 2009], Developer.com, 2009-01-14. Retrieved 2010-03-26.</ref>

MySQL Workbench has been reviewed by the open source community and print magazines.<ref>Jack Wallen, [http://www.linux.com/learn/tutorials/293621-get-to-know-mysql-workbench "Get to Know MySQL Workbench"], Linux.com, 2010-03-16. Retrieved 2010-03-26.</ref><ref>Konstantin Mirin, [http://programmersnotes.info/2009/03/01/mysql-workbench-the-database-modeling-tool-for-mysql/ "MySQL Workbench – The Database Modeling Tool for MySQL"], programmersnotes.info, 2009-03-01. Retrieved 2010-03-26.</ref><ref>Cal Evans, [http://blog.calevans.com/2009/07/05/mysql-workbench-a-superficial-review/ "MySQL Workbench – A Superficial Review"], blog.calevans.com, 2009-07-05. Retrieved 2010-03-26.</ref><ref>[http://www.linuxpromagazine.com/Resources/Current-Issue MySQL Workbench 5.1: Too many tables and too many complex relationships? Visualize your MySQL database with MySQL Workbench.], ''Linux Magazine'', 2001-03-19. Retrieved 2010-03-26.</ref>

==See also==
*[[Comparison of database tools]]

==References==
{{Reflist}}

==External links==
*{{Official website}}
*[https://dev.mysql.com/doc/relnotes/workbench/en/ MySQL Workbench Release Notes]

{{MySQL}}

[[Category:MySQL]]
[[Category:Database administration tools]]
[[Category:Data　modeling tools]]
[[Category:Lua (programming language)-scriptable software]]
[[Category:Software that uses Scintilla]]

MySQL Workbench - Revision history

imported>Moretti: +data from wikidata