Upgrade MySQL workbench on Ubuntu 12.04 was hard job to me because of conflicting with older version of MySQL workbench. I installed MySQL workbench 5.2.38 previously using “sudo apt-get install mysql-workbench” this command. But this version has many hanging and crashing issues with Ubuntu 12.04. So I decide to update the latest version of MySQL workbench. I faced many problems while doing upgrade. So here I would like to share the process and solution to upgrade the software version.
Step 1 – Removing MySQL workbench old version
We can uninstall the old version using below command. Execute this command in your terminal.
sudo apt-get remove mysql-workbench
Step 2 – Download latest version
We can download latest version package from MySQL official website.
Step 3 – Install the new package
mysql-workbench-gpl-5.2.47-1ubu1204-amd64.deb (latest version) file will be downloaded in downloads folder normally. Just right click on downloaded file and click on open with Ubuntu software center. Then install the software. If the package installed properly means no issue. But In my case I got error like below.
Errors were encountered while processing:
…..
Processing triggers for desktop-file-utils …
Processing triggers for gnome-menus …
Processing triggers for hicolor-icon-theme …
Processing triggers for shared-mime-info …
Errors were encountered while processing:
/home/*/Downloads/mysql-workbench-gpl-5.2.47-1ubu1204-amd64.deb
Step 4 – Solution
I searched for hours to get this solution. Finally I found following two commands, execute these commands in your terminal.
sudo apt-get autoclean sudo apt-get autoremove
These two commands did the magic for me. If you have interest to know what these commands, refer in Ubuntu forum.
Final step – Upgrade MySQL workbench by Install the latest package
sudo dpkg -i /home/gowri/Downloads/mysql-workbench-gpl-5.2.47-1ubu1204-amd64.deb
Execute the above command in terminal, I believe latest package will be install successfully. Now my MySQL workbench is working without hanging and crashing.
I continue getting:
pdfisher@horsefly:~$ mysql-workbench
/usr/libexec/mysql-workbench-bin: symbol lookup error: /usr/lib/mysql-workbench/libwbpublic.so.0: undefined symbol: _ZTIN9ctemplate16TemplateModifierE
pdfisher@horsefly:~$
Not so far I have found new cool tool to work with mySQL on ubuntu – Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview
Еxcellent аrtіcle. I’m
facing some of these issues as well..
So happy I found this – this was a lifesaver. My main laptop crashed just as I’m nearing a major MySQL Workbench project for college, and I had to scramble to find out how to install it on my Ubuntu laptop. Thank you SO much. 😀
Thank you for sharing these commands. Helped me immediatly to uninstall an old version and upgrading to a new one.
Hi, I’m getting same problem.
How to fix it?