Mysql WorkBench 5.1 on Linux/Ubuntu

Sep 23rd, 2008
I am building a new database driven website for fun and decided to check on teh status of Workbench and see if they had a Linux version. As luck would have it, they launched a Linux version a couple of days ago! I downloaded the binary for Ubuntu from MySQL and tried to run it, but it spewed out errors. Searching around some more, I found an article on MySQL that talking about building from source on Ubuntu, and copied and pasted the apt-get install for all the dependencies. I opened a terminal, cd'ed to the bin directory and issued "./mysql-workbench" and voila, the program opened. After creating a new diagram and trying to edit a table, I got a segfault. Looks like I'll have to build it. Following the aforementioned article, I issued "sudo apt-get install libcairo2-dev", and found that I already had that library installed, so I followed the directions and installed Google's ctemplate library. Then I downloaded source, complied to tried to install and ran into errors - most of which had to do with Cairo. Upon closer inspection, I realized I didn't Cairo build with support for glitz, just used the version available with Ubuntu. Ahhh, the joys of Linux. Back to the drawing board, where I was able to install Cairo with Glitz enabled, then compile Workbench from source. Quickly had a chance to play around with it and it is no longer segfaulting when I edit a table, but not sure how stable it is until I get more time. To recap, here is what I did to get it working:
  1. sudo apt-get install 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 libglitz-dev libglitz-glx-dev libpixman-1-dev libpcre3-dev g++ libgnome2-dev libgtk2.0-dev libpango1.0-dev
  2. sudo apt-get source cairo
  3. Extract the cairo tarball and cd into the folder
  4. ./configure -enable-glitz
  5. make
  6. make install
  7. Download the source for workbench and extract it, and cd into the folder
  8. ./autogen.sh
  9. make
  10. make install DESTDIR=/home/rlbolton/apps/mysql-workbench (obviously choose a destination dir appropriate for you)
I am actually amazed I got everything to work, considering my very limited knowledge of Linux. Now we'll see how stable the app is... And thanks to MySQL for making a Linux version!

Posted In: mysql, Ubuntu

Commentary

moo 2008-10-05 20:05:09

Thanks alot, worked.

Administrator 2008-10-13 01:49:40

I have had some issues with Workbench, the biggest of which is it won't open a saved diagram.I tried to send the file to a windows box with Workbench, but it won't open on windows either, saying the file was created with a different build (or something like that) This is alpha, tread carefully!

DiarioLinux » Cómo compilar MySQL Workbench 5.1.4alpha 2008-12-06 21:25:35

[...] Si instalamos el paquete binario de MySQL Workbench en Ubuntu , parece que todo funciona bien en un primer momento, pero cuando creas una tabla e intentas cambiarle el nombre (o pedir sus propiedades), la aplicación se cierra (Segmentation Fault). Siendo una versión alpha tampoco es para tirarse de los pelos… no obstante, viendo pantallazos de lo que puede llegar a hacer, y habiéndola necesitado varias veces ya desde que la instalé, me he decidido a compilarla desde 0. Eso que parecía algo muy complejo se resuelve en 15 minutos, sin problemas. A partir de ahí, todo funciona perfectamente (hasta donde he podido probar), sin cuelgues ni cierres inesperados. Vamos allá con el procedimiento (basado en este artículo): [...]

dt 2009-02-22 02:09:47

I'm running Kubuntu 8.10, andI also had to download, configure, make and install ctemplate, found at http://code.google.com/p/google-ctemplate/downloads/list. Maybe you already had it installed?