MySQL Workbench 5.1 1st Alpha for Mac OS Available

Our Mac Developers have done an outstanding job in catching up with the Mac frontend. We have worked hard in the last days to get a little Christmas present out for all people waiting for a Mac Version of our Database Tool.
It’s a 1st alpha version, so don’t expect a full blown design application already – and the binary is Intel only this time (hey, it’s only Christmas folks ;).  But what we deliver is a working UI where you can load/save existing Workbench-documents and create diagrams from imported SQL-scripts. The canvas and the GRT system is up and running and there’s a shell which enables messing with the objects on GRT level. There are no object editors yet (so you can’t create and edit objects, but still build your diagrams for your existing SQL CREATE scripts) and wizards for exporting scripts, and connecting to databases are also missing. But enough writing, grab the .dmg package from our server and give it a try to get yourself a picture of what Workbench is going to look & feel natively on your Mac.  Note that Workbench for Mac requires Mac OS X Leopard.

Binary Package

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.6-osx10.5-i686.dmg
ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.6-osx10.5-i686.dmg.md5

Source Package

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-oss-5.1.6.tar.gz
ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-oss-5.1.6.tar.gz.md5

As example to get you started I’ll give a short step-by-step guide on how to import your script and assemble a nice diagram from it:

  1. download the package from our FTP-Server
  2. open the downloaded Package, you should see a Finder-window opening like this:

    finder install screen (mac)

  3. drag the Workbench-Icon into your Application Folder (or another location of your choice). You can eject the downloaded .dmg file after copying has finished.
  4. launch MySQL Workbench
  5. select the command Reverse Engineer MySQL Create Script … to import your SQL script or dump as seen

    selecting Reverse engineer sql script from menu (mac)

  6. You should see the imported objects on Workbench’s MySQL Model-Page

    sakila SQL script imported into Workbench (mac)

  7. Double-click the Add Diagram Icon in the EER Diagrams section to add a shiny new diagram
  8. Switch to the canvas of the just created diagram by double-clicking the EER Diagram icon that was added in previous step
  9. Grab a database object from the Catalog-Pane on the right sidebar and drop it on the canvas – voila, you’ve just placed your first diagram-figure!
    (you can add more than one items at once by selecting multiple objects by holding the Shift key while selection objects in the catalog-pane)

    drag objects from catalog pane to canvas (mac)

  10. Place your objects on the canvas, arrange them nicely using Layers to visually group different objects and spice it all up by adding Images (the tools for images and Layers can be found on the toolbar to the left).
  11. Archive the creation by saving the file (so you don’t have to start from scratch when next alphas arrive and you want to add additional objects to your schema)
  12. Finally you can output the masterpiece by exporting the whole diagram into a PDF. Find this function under File->Export->Export a Single Page PDF …
    (Be aware that this menu-item is only available when a canvas view is active, not on the “Model Page”)

    export Diagram to PDF (mac)

Following these steps should have given you a starting point on what you can do (and will be able to do as the version gets closer to completion). Please try it out on your Apple and let us know how you like it.

oh, and of course,
Merry Christmas!

13 thoughts on “MySQL Workbench 5.1 1st Alpha for Mac OS Available”

  1. Great work! Thanks a lot and keep it up!

    MySQL Workbench is one of the few reasons left besides gaming to switch to Windows every now and then. All the rest of my workflow has already been moved to OS X lately, but there’s now alternative to Workbench.

    So, thanks again and happy new year!

  2. Its wonderful, but if you have a very large database, it’s very dificult to understand the diagram and almost impossible to layout correctly.

    An algorithm called ortogonal drawing can automatically layout ER diagram with minimum crosses.

    It will be incredible if in the future the MySQL Workbench team implement the algorithm and save us much time.

    We implement an open source version of orthogonal drawing for MySQL and can be found here http://www.amarello.com.mx/downloads/dibujado-ortogonal-mysql/version-online/

    The library called OGDF already implement orthogonal drawing for UML and is written in C++, http://www.ogdf.net/ogdf.php

  3. eduardo, thanks for your links. We have already implemented an algorithm to take care of basic layouting but it has not yet been enabled in the Mac release. Also, we are constantly searching for improved options.

    We cannot ship the OGDF library directly, because it is released under the GPLv2/3. But it would be very interesting to create a Workbench plugin using that library for advanced automatic layout purposes.

    We are currently in the process of refining the Workbench plugin API and also plan to host all available Workbench plugins on our site.

    So if somebody would be interested in creating a plugin using this library, that would great!

  4. Hi,

    I have been waiting for mac version of the workbench… Now that its here I cannot download it. Anything wrong with the FTP server or is it me?

    “Safari can’t open the page “ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.6-osx10.5-i686.dmg” because it could not load any data from this location.”

    Please help!

  5. This is awesome. It feels alpha only for the unimplemented functions; otherwise, it feels as strong as oak! Keep on the good work; I’m anxious to use it in a production environment.

  6. Am I missing something.
    When I go to create a new diagram for a new database, I don’t have the add table icon that I have in the Windows version.
    Is that not in the Alpha?
    That is my most frequent use of the tool is when building a new database schema.

  7. Just downloaded MySQL Workbench 5.1 1st Alpha for Mac OS. Looks nice, played around with it and suddenly I received an “unexpected error”. No idea why. But I’ll be using this release and I need it for my work right now.

  8. Hi guys

    This release is a very early alpha and don’t have most features implemented yet, it was just meant for working on reverse engineered models. Adding tables and other stuff is going to be implemented soon.

    The download problem must have been something temporary, I can download it from the ftp link from my home machine.

    As for crashes, if you get any, please try to get as much information as possible about how to repeat it and report as a bug in http://bugs.mysql.com

Leave a Reply