Using MySQL Workbench with XAMPP

David Coveney from interconnectit.com has written an excellent tutorial of how to use MySQL Workbench with XAMPP, a very nice bundle of Apache, MySQL, PHP and Perl. If you are running XAMPP or what to give it a try, make sure to check out his tutorial that describes how to set the correct MySQL Server Instance profile parameters.

This tutorial is also a good resource for people who do not use a default installation of MySQL and need to manually adjust their MySQL Server Instance profile parameters in order to make their setup work with MySQL Workbench. Default installations should work out of the box of course.

Please find the tutorial here: http://www.interconnectit.com/764/using-mysql-workbench-with-xampp/

EOL of MySQL Query Browser, MySQL Administrator, MySQL Migration Toolkit

With the beta releases of MySQL Workbench 5.2 well under way, we recently announced the EOL (http://www.mysql.com/support/eol-notice.html) of the MySQL GUI Tools Bundle.

The MySQL Tools team has been working on MySQL Workbench 5.2 to give DBAs and developers an integrated tools environment for:

  • Database Design & Modeling
  • SQL Development (replacing MySQL Query Browser)
  • Database Administration (replacing MySQL Administrator)

MySQL Workbench 5.2 also provides:

  • Remote Administration (using SSH-Tunneling)
  • Python scripting and plugins
  • Native GUI for Windows, Mac, Linux

A future release of MySQL Workbench (post 5.2) will add a migration plugin, providing features comparable to the MySQL Migration Toolkit component of the MySQL GUI Tools Bundle.  We will also be adding many other enhancements and new features.

Thanks go out to the community for the great feedback, new ideas, and bug reports on Workbench.  That helps immensely. We promise to keep listening and working hard to incorporate your feedback in improving the product.

To learn more about MySQL Workbench:

Best Regards,

Mike Zinner, Lead MySQL GUI Tools

MySQL Workbench Webseminar

To all people, interested to see a presentation/live demo of MySQL Workbench 5.1 and 5.2 – you’re welcome to join the MySQL Workbench Web-Seminar, held tomorrow, May 27th at 15:00 CET. Important side-note: it’s held in German!
For about 45 minutes I will walk you through various parts of the application and show many features live from my screen:

  • Overview of the interface
  • How to create tables and other objects
  • Layouting objects on the canvas
  • Show how to get your model to the database (and back)
  • Take a quick look into the scripting interface
  • See the database querying of upcoming 5.2 in action

Every participant will be able to ask questions via chat during the presentation and subsequently there will be a Q&A for about 15 mins. The session is free to attend, all you need to do is head over to the Registration-page and enter your data:

http://www.mysql.de/news-and-events/web-seminars/display-341.html

Once again – just a reminder – language used for this session is German. Looking forward to meet you online tomorrow!

MySQL Workbench replacing MySQL Query Browser

Our lastest Alpha2 release of MySQL Workbench 5.2 made it pretty clear that one of our main goals for WB 5.2 is to replace the old MySQL Query Browser (QB) tool.

Even this Alpha2 release already covers most of the essential QB functionality, while at the same time removes some of the biggest limitations that the old QB tool suffers from. Here is a short list of the most important features.

MySQL Workbench 5.2 Features replacing QB

  • Database Connection management
  • SQL statement editor with syntax highlighting
  • Edit multiple statements at the same time (scripts)
  • Editable result sets for table data
  • Database Schema browsing

New MySQL Workbench 5.2 Features

  • Intuitive Database Connection listing on Home page and direct access to SQL Editor
  • Ability to open SQL Editors for many different connections at the same time
  • Instant SQL parsing and syntax error detection while typing
  • Dedicated Output tab-sheet showing database server output
  • Dedicated History tab-sheet showing time-sorted execution history
  • Connection Info tab

MySQL Workbench 5.2 improvements (in respect to QB)

  • One single, unified editor for SQL Queries and Scripts
  • Multiple result sets for SQL Scripts displayed on individual tab-sheets
  • No auto-commit after each execution, possibility to use SQL session variables
  • Automatic limiting of number of result set rows to avoid unwanted network traffic
  • More intuitive, streamlined interface
  • Schema tree fetches data on demand, preventing freezes for huge catalogs

Planned Feature Additions in future Releases

  • Easy to use live Catalog overview & management (in the style of the MySQL Model Page)
  • Live Database Object Editors (reusing the powerful Table/View/Routine editors)
  • SQL Snippets repository
  • New MySQL HTTP Tunneling Connector, allowing owners of web accounts to upload a PHP page to access their database

Please give this early Alpha version a try and tell us what you think.  Your ideas are very welcome!

Sidenote: If you just want to use MySQL Workbench as a schema modeling tool, stick to WB 5.1. We have not added any new modeling features in WB 5.2 yet – and as the model file format has changed – you cannot open your 5.2 models in 5.1 or 5.0 anymore.

MySQL Workbench Workshop Online

Last week we did a Workbench tutorial and three workshops at the MySQL Users Conference. One reason for that was to get people familiar with schema design principles and MySQL Workbench in general. The other reason was to watch people using the tool and learn how we can improve in the UI. We learned a lot and already made some improvements in the next releases that are due this week.

Thanks for everybody attending our sessions and also a big thank you to Mike Hillyer who did a very good job presenting the material.

The material for this workshop as well as a live recording can be found here.

Enjoy!

MySQL Workbench 5.0.29 Released

Wasn’t there a release just some days ago, you might ask? Yes, indeed – but we had to create a quick follow-up because a nasty bug found its way through our test and into the recently released 5.0.28. A bit of debug code from our latest canvas changes was left behind and causes Workbench to crash under certain circumstances. Once discovered we found and fixed the root of the problem quite quickly. Additionally we introduced some new icons last time which didn’t find their way into the installer script as well … so frankly its a quickly delieverd follow up to fix 2 things we missed on last release.
We strongly recommend to update to this release asap.

Download version 5.0.29 from our Download Page or – for our SE users – use the integrated update wizard to get you up2date.

MySQL Workbench 5.0.27 Ready for Download

We have finished the next release of MySQL Workbench 5.0 GA, 5.0.27. It features a number of bugs fixed, especially in the synchronization code, a huge improvement in terms of memory usage and an updated layer-pane, listing all objects on a diagram-canvas – now including conections too (this allows easy selection of hidden objects). Use the Update-function from the help menu or head over to the download pages to get your copy:

http://dev.mysql.com/downloads/workbench/5.0.html

Please let us know if bigger models now load faster and if you are seeing an improved performance of the canvas.

MySQL Workbench 5.1.3 Alpha For Linux Available

We’ve just finished the next alpha-release of our 5.1 version. It has become a bit more stable, we’ve cleaned up the source code, added fixes for building on distros other than Ubuntu and we’ve brushed up our packaging mechanism for Ubuntu – so we can now offer a Repository for use with apt (either on command-line or via Synaptics). There’s only one package – google’s cTemplates – that you’ll still have to install manually before handing the work over to apt to fetch and install workbench on your Ubuntu system.

So first head over to google’s cTemplate-Pages to get libctemplate0. It’s best to fetch the latest .deb package, which you can then install with one simple command like this:

sudo dpkg -i libctemplate0_0.91-1_i386.deb

The next step is to add our Repos to your apt-sources. Do this by adding following lines to your /etc/apt/sources.list file:

deb ftp://ftp.mysql.com/pub/mysql/download/gui-tools/ubuntu/ binary/
deb-src ftp://ftp.mysql.com/pub/mysql/download/gui-tools/ubuntu/ source/

Alternatively launch Synaptics (System->Administration->Synaptics Package Manager) and select Settings->Repositories, switch to the second tab-page named Third-Party Software, click [Add] and enterthe two lines above (you’ll have to addthe first line, click [Add Source] and hit [Add] again for the second line)

Now tell apt to update its repo-information. Hit the [Reload] button in Synaptics or when on cmd-line type:

sudo apt-get update

Finally tell apt to install MySQL Workbench 5.1 alpha by either locating the Package (Filed in section ‘Utilities’) and selecting it for installation or type following command at your shell prompt:

sudo apt-get install mysql-workbench

Following the steps above should result in a runable Workbench-Application on your Ubuntu-box. Note that we currently only offer i386 packages, if you need a package for some other architecture, please build it from sources. For all non-Ubuntu-users who are willing to try building workbench on their systems we have uploaded a source tarball to the following location:

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.3-alpha.tar.gz
ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.3-alpha.tar.gz.md5

Please keep on posting/writing, we very much appreciate your input on fixes for building on other distros and your opinions and experiences. Theres another release coming this week – the next release of our GA version 5.0, so stay tuned

Perspective: Addons and Community site

Along with evolving and documenting interface for writing Workbench plugins we think about community site which will make sharing and usage of plugins within community extremely easy. Conceptually it will be close to addons.mozilla.org. Users will be able to explore directory of published addons, read description and comments on them, quickly install and rate whatever they consider necessary. To install selected addon user will have just to drag’n’drop corresponding link to Workbench, and the rest will be done by Workbench. Every addon will be supplied with manifest file describing its version, dependencies on other addons (if any), files to be installed, menu items to be added, etc. Addon has wide definition, it could be a plugin (dynamic library), set of demo models, documentation, SQL scripts, whatever. Now things are nearly in the middle of development stage. If you have ideas on how to improve the process of sharing/publication/discussion/promotion of community written addons please let us know in dedicated forum http://forums.mysql.com/list.php?155. Help us to reach a maximum of usability with Workbench community site.