Sunday, April 1, 2012

Install MySQL Workbench on Ubuntu 12.04

Currently there is no pre-built .deb file or repo available to install MySQL Workbench on Ubuntu 12.04.  One will probably appear soon after official release of 12.04 but at the moment it is still in beta so there are a few extra steps to get it working.

NOTE: Once Ubuntu 12.04 moves out of beta there will probably be a better way of doing this so please check the official MySQL Workbench download page and the official 12.04 repos before attempting this.

First of all you will need to download the latest MySQL Workbench from here.

Next you must download a .deb file for libzip1 as it is not available in the 12.04 repos.

32 bit version - https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_i386.deb
64 bit version - https://launchpad.net/ubuntu/+source/libzip/0.9.3-1/+build/1728114/+files/libzip1_0.9.3-1_amd64.deb
for other architectures go here

After downloading just open them with the software centre and click install.

*NEW: The libmysqlclient16 package was removed from the 12.04 repos so you will need to download the old deb files for it:

32 bit version - http://launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb
64 bit version - http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb


 Next open a terminal and install the following packages:

sudo apt-get install libzip1 python-paramiko python-pysqlite2 libctemplate0 libgtkmm-2.4-1c2a libmysqlclient16

Then cd to the directory where you downloaded the deb file and run:

sudo dpkg -i mysql-workbench-gpl-5.2.38-1ubu1104-i386.deb

And that should be it, enjoy!

Instructions loosely based on those found here: http://blog.csdn.net/kevin6216/article/details/7420421




25 comments:

  1. libzip1 doesn't exist in the 12.04 repos. Is there a way to use libzip2 which does?

    ReplyDelete
    Replies
    1. I imagine you could download the source and compile using libzip2 instead of 1. when the official release hits that'll probably be the case. Until then though i just needed a quick and dirty fix

      Delete
  2. THANK YOU!!!
    Been struggling for a day with this, but did not know how to get libzip1. How did you figure that out?

    ReplyDelete
    Replies
    1. lol, lots of screwing around, really wanted to move all my computers to 12.04 but really need workbench for work.

      Delete
  3. Need libzip1?
    Just install from Oneiric repo...
    https://answers.launchpad.net/ubuntu/oneiric/i386/libzip1/0.9.3-1

    ReplyDelete
  4. Maybe I am too cautious but I took the Debian packages directly from debian.org.

    http://security.debian.org/debian-security/pool/updates/main/m/mysql-5.1/libmysqlclient16_5.1.61-0+squeeze1_amd64.deb
    http://ftp.de.debian.org/debian/pool/main/libz/libzip/libzip1_0.9.3-1_amd64.deb

    ReplyDelete
    Replies
    1. The links I posted are to launchpad, which is owned and maintained by Canonical(the guys who make Ubuntu) so I'm pretty sure the files are safe.

      Delete
  5. Amazing! Thanks for this article. I've been sat here scratching my head for ages. I never thought of just downloading the older version of libzip!

    ReplyDelete
  6. Thank you very much. This helped a lot!!!

    ReplyDelete
  7. Thanks, this is exactly what I needed. MySQL Workbench was the last piece of the puzzle that makes up my development environment.

    ReplyDelete
  8. You should now be able to install the mysql workbench available in the Ubuntu Software Center in 12.04. I just searched it and found v5.2.38 which installed perfectly in 12.04. Nice and easy.

    ReplyDelete
  9. Thank you, worked fine for me !

    ReplyDelete
  10. you are the man.....


    Smooth tutorial. thanx
    :-)

    ReplyDelete
  11. Thanxs a million time for this post, got stuck for a while with my mysql workbench install on Kubuntu 12.04 !
    Marc

    ReplyDelete
  12. MySql Workbench is now available for Ubuntu 12.04
    http://www.ubuntuupdates.org/package/core/precise/universe/base/mysql-workbench

    ReplyDelete
  13. Excellent!!! only your instructions works... from MySql forums not... :)

    Thanks a lot...

    ReplyDelete
  14. Worked perfectly. Thanks a bunch.

    ReplyDelete
  15. Thanks. Works for Linux Mint 13 too.

    Dom

    ReplyDelete
  16. Take a look on free tool Valentina Studio, is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases for free on 32/64 bit Windows, Linux and Mac OS X. http://www.valentina-db.com/en/valentina-studio-overview

    ReplyDelete
  17. Install MySQL Workbench is a nice post. thank for share about it.
    free softwares downloads for pc

    ReplyDelete