Friday, 12 March 2021

How to install MySQL Workbench on Ubuntu

Ubuntu 20.04 in my case.

We first need to download the deb package from the Oracle website:



Read How to check file GPG signature on Linux | My Public Notepad and don't skip that step! Now we can try to install the package:

$ sudo dpkg -i mysql-workbench-community_8.0.23-1ubuntu20.04_amd64.deb 
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 304721 files and directories currently installed.)
Preparing to unpack mysql-workbench-community_8.0.23-1ubuntu20.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.23-1ubuntu20.04) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libzip5 (>= 0.10); however:
  Package libzip5 is not installed.

dpkg: error processing package mysql-workbench-community (--install):
 dependency problems - leaving unconfigured
Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
Processing triggers for desktop-file-utils (0.24-1ubuntu3) ...
Processing triggers for mime-support (3.64ubuntu1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for shared-mime-info (1.15-1) ...
Errors were encountered while processing:
 mysql-workbench-community


To fix the dependencies:

sudo apt --fix-broken install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Correcting dependencies... Done
The following additional packages will be installed:
  libzip5
The following NEW packages will be installed
  libzip5
0 to upgrade, 1 to newly install, 0 to remove and 38 not to upgrade.
1 not fully installed or removed.
Need to get 46.7 kB of archives.
After this operation, 134 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://gb.archive.ubuntu.com/ubuntu focal/universe amd64 libzip5 amd64 1.5.1-0ubuntu1 [46.7 kB]
Fetched 46.7 kB in 1s (75.4 kB/s)
Selecting previously unselected package libzip5:amd64.
(Reading database ... 306005 files and directories currently installed.)
Preparing to unpack .../libzip5_1.5.1-0ubuntu1_amd64.deb ...
Unpacking libzip5:amd64 (1.5.1-0ubuntu1) ...
Setting up libzip5:amd64 (1.5.1-0ubuntu1) ...
Setting up mysql-workbench-community (8.0.23-1ubuntu20.04) ...
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...

Installation is now successful:

$ sudo dpkg -i mysql-workbench-community_8.0.23-1ubuntu20.04_amd64.deb 
(Reading database ... 306011 files and directories currently installed.)
Preparing to unpack mysql-workbench-community_8.0.23-1ubuntu20.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.23-1ubuntu20.04) over (8.0.23-1ubuntu20.04) ...
Setting up mysql-workbench-community (8.0.23-1ubuntu20.04) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
Processing triggers for desktop-file-utils (0.24-1ubuntu3) ...
Processing triggers for mime-support (3.64ubuntu1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for shared-mime-info (1.15-1) ...

Let's try to run it:

$ mysql-workbench --version
Workbench can't find libproj.so, some options may be unavailable.
MySQL Workbench CE (GPL) 8.0.23 CE build 365764

For this warning, see here: MySQL Workbench not opening on ubuntu - Stack Overflow

That library is not present on my machine:

$ sudo find / -name libproj.so

But as one comment said, it is optional so the app worked fine:



No comments: