MySQL Workbench not opening on ubuntu

Viewed 11784

While I am trying to open my installed MySQL workbench it is not opening, I try to open using terminal it shows the below error:

command:

mysql-workbench

Error:

> Workbench can't find libproj.so, some options may be unavailable.
> /usr/bin/mysql-workbench-bin: error while loading shared libraries: libzip.so.4: cannot open shared object file: No such file
> or directory

I've tried to install broken packages and creating symbolic link but also I am not able to fix.

Can someone help to solve this issue?

Thanks in advance.

2 Answers

if running mysql-workbench command gives following warning:

    Workbench can't find libproj.so, some options may be unavailable.

run this command to check if you have the above mentioned file :

 $ find / -name libproj.so 2> /dev/null

if not found, then run this command to install the lacking file dependency to remove the warning:

 $ sudo apt install libproj-dev proj-bin

It will remove the warning. Worked for me. Please try in your system. Below is my command output:

 $ find / -name libproj.so 2> /dev/null
 /usr/lib/x86_64-linux-gnu/libproj.so
 $ mysql-workbench
 Found /lib/x86_64-linux-gnu/libproj.so.15

(Note: even if this warning was there, my Workbench was still running properly. I followed the above mentioned steps just to get rid of that warning.)

Reinstalling workbench and doing --fix-broken install worked for me.

Details:

  1. Uninstall workbench

sudo apt remove mysql-workbench

  1. Clean

sudo apt clean

sudo apt autoremove

  1. Update repos

sudo apt update && apt upgrade

  1. Install workbench again

sudo apt install mysql-workbench

  1. The fix

sudo apt --fix-broken install

  1. Run workbench

mysql-workbench

Related