MySQL Workbench 5.2.37 GA Available

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.37.  This release contains 21 bug fixes, including a fix for a slowdown on loading of schema objects in the SQL Editor. MySQL Workbench 5.2 GA • Data Modeling • Query (replaces the old MySQL Query Browser) • Administration (replaces the old MySQL Administrator) Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux. http://dev.mysql.com/downloads/workbench/ Workbench Documentation can be found here. http://dev.mysql.com/doc/workbench/en/index.html In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness. This release also includes improvements to ...

Posted in Announcements | 3 Comments »

MySQL Workbench 5.2.36 GA available

MySQL Workbench 5.2.36 has been released. This release is part of an ongoing effort committed to improving the day to day usability of the product based on accumulated experience from tools such as MySQL Query Browser and input from user feedback. This specific version was focused on improving usability of the Query Editor. Some of the changes introduced are: New, redesigned Query Editor layout. Output messages are always visible while resultsets and the query editor can be resized according to the task at hand. Resultsets are now in the same tab as their generating query editor. Several minor changes that make the difference for a frustration-free, comfortable use of the tool. Sidebar sizes, the last selected schema and other state information is now ...

Posted in Announcements, Linux, Mac, Windows | 10 Comments »

MySQL Workbench 5.2.36: What’s New

MySQL Workbench 5.2.36 is now out and brings a lot of improvements across the board, with special focus on the Query Editor. We'll cover some of that here: Redesigned Query Editor The log of executed commands and server responses is now always visible while resultset grids and the query editor can be resized according to your needs. Resultsets are also grouped in the same tab as the query editor that generated them. SELECT queries are now analyzed as in the old MySQL Query Browser tool and, if possible, its resultset can be edited in the grid. If the resultset cannot be edited, you can place the mouse over the ReadOnly label and view the reason. Improved snippets manager and editor, allows having snippets list ...

Posted in Administration, News, SQL editor | No Comments »

Startup problems with 5.2.35? Get 5.2.35.1

In the latest release of MySQL Workbench (5.2.35), we received a number of reports that some people upgrading over a previous installation ended up in not being able to launch MySQL Workbench afterwards, instead receiving an error such as Access to the path 'C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.35\db_utils.pyc' is denied. The cause for that seems to be a problem with access privileges on files that are created when Workbench is run. If you run into that problem, a possible workaround should be to start Workbench with elevated privileges one time. To do this, right-click the Workbench application icon in your startmenu and select "Run as administrator". Please leave a comment whether this workaround solves the reported problem for you. UPDATE: ...

Posted in Windows | 8 Comments »

Building MySQL Workbench from sources on Ubuntu/Debian

To build MySQL Workbench one would need to install dependencies, fetch source code, configure it and actually do a build. Note: On a Core2 Quad 2.4 GHz and a 4G of RAM it takes about 30-40 minutes to build Workbench. Also it uses about 4.2G of hdd space to build. Here are steps to build Workbench on Ubuntu/Debian: 1) install deps. It is better to use terminal. The command to install deps is below: sudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libglu1-mesa-dev libmysqlclient15-dev uuid-dev liblua5.1-dev libpcre3-dev g++ libglade2-dev libgnome2-dev python-pexpect libboost-dev libsqlite3-dev python-dev libgnome-keyring-dev libctemplate-dev 2) Get source code from http://www.mysql.com/downloads/workbench/ 3) unpack downloaded archive and run autogen.sh from the unpacked directory. The actual invocation may vary, for example: ./autogen.sh --prefix=/usr/local or ./autogen.sh --prefix=/opt/ --prefix ...

Posted in Linux, Tutorial | 16 Comments »

MySQL Workbench on Ubuntu 11.10

We have seen many reports about broken build and freezes which are experienced on Ubuntu 11.10. While the build fix was pretty simple, the freezes took us a bit more time to hunt them down. The point is that MySQL Workbench relies on glib's idle signals which are emitted when Gtk's main event loop has nothing to do. In Ubuntu 11.10, for some reason, for certain types of windows we use, these idle signals are not emitted cause window drawing code constantly reschedules idle redraws. The bug report which is related to the freezes and compilation problems is at http://bugs.mysql.com/62347 Here is a link to the patch: is http://bugs.mysql.com/file.php?id=17639

Posted in Uncategorized | 13 Comments »

MySQL Workbench Blog is now at mysqlworkbench.org

The URL for the MySQL Workbench community blog is being changed to mysqlworkbench.org. The old URL will soon no longer point to this blog. Nothing else is changing, so update your bookmarks and keep checking for news, announcements and other content of interest for all MySQL Workbench users!

Posted in Announcements | 1 Comment »

MySQL Workbench: PHP development helper plugins

In the new MySQL Workbench 5.2.35, a plugin that will be of interest to PHP developers, both experienced and newbies, has been added. The plugin contains a couple of functions that allows you to create PHP code straight out of your current work in the Workbench SQL Editor, ready to be pasted to your PHP program. Copy as PHP Code (Connect to Server) This first plugin will take the parameters from your currently open connection to MySQL and create PHP code to connect to it. $host="p:localhost"; $port=3306; $socket="/var/mysql/mysql.sock"; $user="root"; $password=""; $dbname=""; $con = new mysqli($host, $user, $password, $dbname, $port, $socket) or die ('Could not connect to the database server' . mysqli_connect_error()); //$con->close(); Not a big deal, but saves some typing for getting something going quickly. Copy as PHP Code (Iterate SELECT Results) This ...

Posted in Coding, Plugins, SQL editor | 6 Comments »

MySQL Workbench 5.2.35 GA Available

The MySQL Developer Tools team is proud to announce the next release of it's flagship product, MySQL Workbench, version 5.2.35. This is the next maintenance release containing 29 bug fixes as well as new feature additions. We also updated the supported platforms to include most recent editions of Fedora and Ubuntu Linux. MySQL Workbench 5.2.35 now supports the Native Windows Authentication Method - available in the commercial MySQL server product - and the creation of user accounts utilizing this new authentication method. For the PHP developers out there, Workbench now also comes with a new set of plugins to turn SQL Queries into PHP code to be put right into your scripts. A big "Thank You" again to everyone for the large amount ...

Posted in Announcements, Linux, Mac, Windows | 24 Comments »

MySQL Workbench, Windows XP and SSH public key auth.

It happens that sometimes you need to access a remote box which supports ssh key authentication. Recently I was trying to reproduce a bug related to SSH public key authentication, so here I would like to share some of my experience. There will be no explanation of the public key authentication itself here, rather the actual setup and steps to have a public key auth for Windows(client) -> Linux(server) working. Why Windows you would ask? Because interactions for Linux->Linux and for Mac OS X -> Linux simply work using the Unix way, while for Windows you may need some extra actions to do.   Setup What I had at endpoints: Linux - Ubuntu 11.04, sshd is set up to deny password auth. Windows - well, it ...

Posted in Administration, Linux, Windows | 2 Comments »