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:



2 comments:

Dominick said...

Drug store service technicians are licensed as Licensed Drug store Service Technicians by the pharmacy technician resume Accreditation Board. Drug store professionals are likewise provided training in some healthcare facilities, technological colleges, and also universities.

micheal pan said...

BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
you can be to get the new PROGRAMMED blank ATM card that is capable of
hacking into any ATM machine,anywhere in the world. I got to know about 
this BLANK ATM CARD when I was searching for job online about a month 
ago..It has really changed my life for good and now I can say I'm rich and 
I can never be poor again. The least money I get in a day with it is about 
$50,000.(fifty thousand USD) Every now and then I keeping pumping money 
into my account. Though is illegal,there is no risk of being caught 
,because it has been programmed in such a way that it is not traceable,it 
also has a technique that makes it impossible for the CCTVs to detect 
you..For details on how to get yours today, email the hackers on : (
atmmachinehackers1@gmail.com ). Tell your 
loved once too, and start to live large. That's the simple testimony of how 
my life changed for good...Love you all ...the email address again is ;
atmmachinehackers1@gmail.com