{"id":229,"date":"2012-04-04T22:13:54","date_gmt":"2012-04-04T12:13:54","guid":{"rendered":"http:\/\/helms-deep.net\/~rwh\/blog\/?p=229"},"modified":"2012-04-25T18:55:07","modified_gmt":"2012-04-25T08:55:07","slug":"how-to-build-mysql-workbench-on-ubuntu-precise-pre-release","status":"publish","type":"post","link":"https:\/\/helms-deep.net\/~rwh\/blog\/?p=229","title":{"rendered":"How to build MySQL Workbench on Ubuntu Precise (pre-release)"},"content":{"rendered":"<p><strong>Update 2012-04-25<\/strong>: mysql has appeared in the <a href=http:\/\/packages.ubuntu.com\/precise\/mysql-workbench>universe package archive<\/a>.  You should be able to install it with a simple:<\/p>\n<pre lang=\"bash\">sudo apt-get install mysql-workbench<\/pre>\n<p>Read on if you still want to compile from source.<\/p>\n<p>Right now (2012-04-04), Ubuntu 12.04 hasn&#8217;t been released yet, and so there is no binary package from Oracle of MySQL Workbench for Precise.  I managed to get the <a href=http:\/\/dev.mysql.com\/downloads\/workbench\/>MySQL Workbench binaries for Oneiric<\/a> to run, by manually installing libzip1_0.9.3-1_amd64.deb from Oneiric, but this wasn&#8217;t stable (crashed as soon as I tried to run a SQL Query).<\/p>\n<p>So I decided to build from source.  Here&#8217;s how I did it<!--more-->:<\/p>\n<pre lang=\"bash\">wget http:\/\/www.mirrorservice.org\/sites\/ftp.mysql.com\/Downloads\/MySQLGUITools\/mysql-workbench-gpl-5.2.38-src.tar.gz\r\nmd5sum mysql-workbench-gpl-5.2.38-src.tar.gz\r\n# should be cd2a0cec9dffd5465b6999f5d9c8de78 (from http:\/\/dev.mysql.com\/downloads\/workbench\/#downloads).\r\ntar xvzf mysql-workbench-gpl-5.2.38-src.tar.gz\r\ncd mysql-workbench-gpl-5.2.38-src\r\n# from http:\/\/bugs.mysql.com\/bug.php?id=63898\r\nfgrep -rlZ pkglib_DATA --include Makefile.am . | xargs -0 sed -i 's\/pkglib_DATA\/pkgdata_DATA\/g'\r\n# from https:\/\/bugzilla.redhat.com\/show_bug.cgi?id=750023\r\nvim .\/modules\/db.mysql.sqlparser\/src\/mysql_sql_parser_fe.cpp<\/pre>\n<p>change line 23 from:<\/p>\n<pre>#include &lt;glib\/gunicode.h&gt;<\/pre>\n<p>to<\/p>\n<pre>#include &lt;glib.h&gt;<\/pre>\n<pre lang=\"bash\">apt-get update\r\n# from http:\/\/ubuntuforums.org\/showthread.php?t=1792874 plus updates from comments below.\r\nsudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libgl1-mesa-dev libmysqlclient-dev uuid-dev liblua5.1-dev libpcre3-dev g++ libgnome2-dev libgtk2.0-dev libpango1.0-dev libcairo2-dev libsqlite3-dev python-dev libboost-dev libctemplate-dev\r\n.\/autogen.sh\r\n# I use -j4 below to use all four of my CPUs, set this appropriately for your setup.\r\nmake -j 4 install DESTDIR=\/home\/`echo $USER`\/mysql-workbench\r\n~\/mysql-workbench\/usr\/local\/bin\/mysql-workbench<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Update 2012-04-25: mysql has appeared in the universe package archive. You should be able to install it with a simple: sudo apt-get install mysql-workbench Read on if you still want to compile from source. Right now (2012-04-04), Ubuntu 12.04 hasn&#8217;t &hellip; <a href=\"https:\/\/helms-deep.net\/~rwh\/blog\/?p=229\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[134,133,129,131,128,127,132,44,130],"class_list":["post-229","post","type-post","status-publish","format-standard","hentry","category-howtos","tag-12-04","tag-build","tag-mysql","tag-mysqlworkbench","tag-pangolin","tag-precise","tag-source","tag-ubuntu","tag-workbench"],"_links":{"self":[{"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=\/wp\/v2\/posts\/229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=229"}],"version-history":[{"count":10,"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=\/wp\/v2\/posts\/229\/revisions"}],"predecessor-version":[{"id":275,"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=\/wp\/v2\/posts\/229\/revisions\/275"}],"wp:attachment":[{"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helms-deep.net\/~rwh\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}