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:


We can choose package which does not contain debugging information files (dbgsym).

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:


Updating Workbench to the latest version


I had version 8.0.23 and check for updates returned 8.0.27. I downloaded the deb file and procedure was the same as for first installation:

$ sudo dpkg -i mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb
(Reading database ... 304933 files and directories currently installed.)
Preparing to unpack mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.27-1ubuntu20.04) over (8.0.23-1ubuntu20.04) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libproj15 (>= 6.3.0); however:
  Package libproj15 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

 
$ 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:
  libproj15 proj-data
Suggested packages:
  proj-bin
The following NEW packages will be installed
  libproj15 proj-data
0 to upgrade, 2 to newly install, 0 to remove and 0 not to upgrade.
1 not fully installed or removed.
Need to get 8,572 kB of archives.
After this operation, 27.5 MB 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 proj-data all 6.3.1-1 [7,647 kB]
Get:2 http://gb.archive.ubuntu.com/ubuntu focal/universe amd64 libproj15 amd64 6.3.1-1 [925 kB]
Fetched 8,572 kB in 4s (2,323 kB/s)
Selecting previously unselected package proj-data.
(Reading database ... 304934 files and directories currently installed.)
Preparing to unpack .../proj-data_6.3.1-1_all.deb ...
Unpacking proj-data (6.3.1-1) ...
Selecting previously unselected package libproj15:amd64.
Preparing to unpack .../libproj15_6.3.1-1_amd64.deb ...
Unpacking libproj15:amd64 (6.3.1-1) ...
Setting up proj-data (6.3.1-1) ...
Setting up libproj15:amd64 (6.3.1-1) ...
Setting up mysql-workbench-community (8.0.27-1ubuntu20.04) ...
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
 
$ sudo dpkg -i mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb
(Reading database ... 304985 files and directories currently installed.)
Preparing to unpack mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.27-1ubuntu20.04) over (8.0.27-1ubuntu20.04) ...
Setting up mysql-workbench-community (8.0.27-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) ...

 

Checking for the updates now shows that no new updates are available:


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