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.