Install MySQL Workbench on Ubuntu 16.04 via Command Line

Posted on

In this article, the focus which is going to be discussed is primarily about installing MySQL Workbench on Ubuntu 16.04 Linux operating system which is most of the steps will be executed via command line.

1. First of all, download the package which can be used for installing MySQL Workbench. Search the package named ‘mysql-workbench-community’ via Google.

2. After downloading the package named ‘mysql-workbench-community’ which in this article it is mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb. Type the following commmand :

dpkg -i mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb

In the case of the installation of the above command, there is an error which is shown in the execution of the command as follows :

root@hostname:/home/user/Downloads# dpkg -i mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb 
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 903628 files and directories currently installed.)
Preparing to unpack mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb ...
Unpacking mysql-workbench-community (6.3.9-1ubuntu16.04) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libgeos-c1v5 (>= 3.4.2); however:
  Package libgeos-c1v5 is not installed.
 mysql-workbench-community depends on libhdf4-0-alt; however:
  Package libhdf4-0-alt is not installed.
 mysql-workbench-community depends on libnetcdf11 (>= 4.0.1); however:
  Package libnetcdf11 is not installed.       
dpkg: error processing package mysql-workbench-community (--install):                                                                                                 
 dependency problems - leaving unconfigured                                                                                                                                                                                      
Processing triggers for menu (2.1.47ubuntu1) ...                     
Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
Unknown media type in type 'all/all'                                       
Unknown media type in type
'all/allfiles'                                                                                                                                                                                         
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...               
Processing triggers for gnome-menus (3.13.3-6ubuntu3) ... 
Processing triggers for desktop-file-utils (0.22-1ubuntu5) ...
Processing triggers for mime-support (3.59ubuntu1) ...                    
Errors were encountered while processing:                                                                                                                                                                                         
mysql-workbench-community                                                                                                                                                                                                        

After searching for a solution, one of the action which can be taken in this context is by the execution of the following package installation :

dpkg -i libzip1_0.9.3-1_amd64.deb

Below is the execution for installing the package on the command prompt line which is using ‘dpkg’ tool for installing a package named ‘libzip1’ :

root@hostname:/home/user/Downloads# dpkg -i libzip1_0.9.3-1_amd64.deb
Selecting previously unselected package libzip1.
(Reading database ... 904898 files and directories currently installed.)
Preparing to unpack libzip1_0.9.3-1_amd64.deb ...
Unpacking libzip1 (0.9.3-1) ...
Setting up libzip1 (0.9.3-1) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
root@hostname:/home/user/Downloads#

After the installation above which is actually processing the installation of a package named ‘libmysqlclient16’, in the following are several attempts which is done to install the similar package which in case is needed in order to run MySQL Workbench as several attempts to solve it. First of all,  download the package using the downloader utility like wget as follows :

root@hostname:/home/user/Downloads# wget http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb
--2017-02-21 20:20:52-- http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb
Resolving launchpadlibrarian.net (launchpadlibrarian.net)... 91.189.89.229, 91.189.89.228
Connecting to launchpadlibrarian.net (launchpadlibrarian.net)|91.189.89.229|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1873326 (1,8M) [application/x-debian-package]
Saving to: ‘libmysqlclient16_5.1.58-1ubuntu5_amd64.deb’

libmysqlclient16_5.1.58-1ubuntu5_amd64.deb 100%[================================================================================================================================>] 1,79M 33,6KB/s in 39s

2017-02-21 20:21:32 (46,9 KB/s) - ‘libmysqlclient16_5.1.58-1ubuntu5_amd64.deb’ saved [1873326/1873326]

You have new mail in /var/mail/root
root@hostname:/home/user/Downloads#

Below is the execution of the package named ‘libmysqlclient16_5.1.58-1’ :

root@hostname:/home/user/Downloads# dpkg -i libmysqlclient16_5.1.58-1ubuntu5_amd64.deb
Selecting previously unselected package libmysqlclient16:amd64.
(Reading database ... 904903 files and directories currently installed.)
Preparing to unpack libmysqlclient16_5.1.58-1ubuntu5_amd64.deb ...
Unpacking libmysqlclient16:amd64 (5.1.58-1ubuntu5) ...
Setting up libmysqlclient16:amd64 (5.1.58-1ubuntu5) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
root@hostname:/home/user/Downloads#

Several attempts also executed by installing several utilites or packages as follows  :

root@hostname:/home/user/Downloads# sudo apt-get -f install python-paramiko libzip2 libmysqlclient18 mysql-client mysql-common python-pysqlite2 libdbi-perl libdbd-mysql-perl libplrpc-perl libnet-daemon-perl mysql-client
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package libmysqlclient18 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'libmysqlclient18' has no installation candidate
E: Unable to locate package libplrpc-perl

After installing the above package, it is actually can be found that a package named ‘libmysqlclient18′ and libplrpc-perl’ need for further installation :

root@hostname:/home/user/Downloads# apt-cache search libmysqlclient18
root@hostname:/home/user/Downloads#

Since ‘libmysqlclient18’ cannot be found in the above execution command, just download it manually by executing the following command :

root@hostname:/home/user/Downloads# wget http://launchpadlibrarian.net/212189159/libmysqlclient18_5.6.25-0ubuntu1_amd64.deb
--2017-02-21 20:24:40-- http://launchpadlibrarian.net/212189159/libmysqlclient18_5.6.25-0ubuntu1_amd64.deb
Resolving launchpadlibrarian.net (launchpadlibrarian.net)... 91.189.89.229, 91.189.89.228
Connecting to launchpadlibrarian.net (launchpadlibrarian.net)|91.189.89.229|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 690052 (674K) [application/x-debian-package]
Saving to: ‘libmysqlclient18_5.6.25-0ubuntu1_amd64.deb’

libmysqlclient18_5.6.25-0ubuntu1_amd64.deb 100%[================================================================================================================================>] 673,88K 57,4KB/s in 14s

2017-02-21 20:24:55 (47,0 KB/s) - ‘libmysqlclient18_5.6.25-0ubuntu1_amd64.deb’ saved [690052/690052]

root@hostname:/home/user/Downloads#

After finishing on downloading the package, below is the execution of the package for installing the package named ‘libmysqlclient18_5.6.25-0ubuntu1_amd64.deb’ :

root@hostname:/home/user/Downloads# dpkg -i libmysqlclient18_5.6.25-0ubuntu1_amd64.deb
Selecting previously unselected package libmysqlclient18:amd64.
(Reading database ... 904910 files and directories currently installed.)
Preparing to unpack libmysqlclient18_5.6.25-0ubuntu1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.6.25-0ubuntu1) ...
Setting up libmysqlclient18:amd64 (5.6.25-0ubuntu1) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
root@hostname:/home/user/Downloads#

This is another package installation which is assumed that it is needed for further installation :

root@hostname:/home/user/Downloads# dpkg -i libplrpc-perl_0.2020-2_all.deb 
(Reading database ... 904949 files and directories currently installed.)
Preparing to unpack libplrpc-perl_0.2020-2_all.deb ...
Unpacking libplrpc-perl (0.2020-2) over (0.2020-2) ...
Setting up libplrpc-perl (0.2020-2) ...
Processing triggers for man-db (2.7.5-1) ...
root@hostname:/home/user/Downloads#

And the next is the installation of another package named libnet-daemon-perl’ which is shown as follows :

root@hostname:/home/user/Downloads# apt-get install libnet-daemon-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
Depends: libhdf4-0-alt but it is not going to be installed
Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads# dpkg -i libnet-daemon-perl_0.48-1_all.deb
Selecting previously unselected package libnet-daemon-perl.
(Reading database ... 904937 files and directories currently installed.)
Preparing to unpack libnet-daemon-perl_0.48-1_all.deb ...
Unpacking libnet-daemon-perl (0.48-1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Processing triggers for man-db (2.7.5-1) ...
root@hostname:/home/user/Downloads#

Since the rest of the package has already been installed without having any additional progress, by seeing the information on alternative for solving the problem, below is the execution of the program using ‘apt-get -f install’ with the argument of packages name  :

root@hostname:/home/user/Downloads# sudo apt-get -f install python-paramiko libzip2 libmysqlclient18 mysql-client mysql-common python-pysqlite2 libdbi-perl libdbd-mysql-perl libplrpc-perl libnet-daemon-perl mysql-client
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libdbi-perl is already the newest version (1.634-1build1).
python-paramiko is already the newest version (1.16.0-1).
python-paramiko set to manually installed.
libnet-daemon-perl is already the newest version (0.48-1).
libplrpc-perl is already the newest version (0.2020-2).
libmysqlclient18 is already the newest version (5.6.25-0ubuntu1).
libzip2 is already the newest version (0.10.1-1.2).
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

Another attempt made :

root@hostname:/home/user/Downloads# dpkg -i mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb 
(Reading database ... 904949 files and directories currently installed.)
Preparing to unpack mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb ...
Unpacking mysql-workbench-community (6.3.9-1ubuntu16.04) over (6.3.9-1ubuntu16.04) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libgeos-c1v5 (>= 3.4.2); however:
  Package libgeos-c1v5 is not installed.
 mysql-workbench-community depends on libhdf4-0-alt; however:
  Package libhdf4-0-alt is not installed.
 mysql-workbench-community depends on libnetcdf11 (>= 4.0.1); however:
  Package libnetcdf11 is not installed.

dpkg: error processing package mysql-workbench-community (--install):
 dependency problems - leaving unconfigured
Processing triggers for menu (2.1.47ubuntu1) ...
Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
Unknown media type in type 'all/all'
Unknown media type in type 'all/allfiles'
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu5) ...
Processing triggers for mime-support (3.59ubuntu1) ...
Errors were encountered while processing:
 mysql-workbench-community

root@hostname:/home/user/Downloads#

After failing to install MySQL Workbench through the execution of the above command program,  trying to install libgeos-c1v5, libhdf4-0alt and libnetcdf11 as follows :

root@hostname:/home/user/Downloads# apt-get install libgeos
Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package libgeos
You have new mail in /var/mail/root
root@hostname:/home/user/Downloads# 

Failing attempt on the previous installation step, try to attempt another package installation :

root@hostname:/home/user/Downloads# apt-get install libgeos-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libgeos-dev : Depends: libgeos-c1v5 (= 3.5.0-1ubuntu2) but it is not going to be installed
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installedackage installation :
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

Trying with another attempt of other program installation :

root@hostname:/home/user/Downloads# apt-get install libnetcdf-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libnetcdf-dev : Depends: libnetcdf11 (= 1:4.4.0-2) but it is not going to be installed
                 Depends: libhdf5-dev (>= 1.8.6-1~) but it is not going to be installed
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

Try to execute another package :

root@hostname:/home/user/Downloads# apt-get install libhdf5-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libhdf5-dev : Depends: libhdf5-10 (= 1.8.16+docs-4ubuntu1) but it is not going to be installed
               Depends: libaec-dev but it is not going to be installed
               Depends: hdf5-helpers but it is not going to be installed
               Depends: libhdf5-cpp-11 (= 1.8.16+docs-4ubuntu1) but it is not going to be installed
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

Another attempt for installing another package :

root@hostname:/home/user/Downloads# apt-get install libhdf5-10
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libhdf5-10 : Depends: libsz2 but it is not going to be installed
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

root@hostname:/home/user/Downloads#

After several attempt on installing several packages or programs above and in the end every single one failed. The following is another attempt by using ‘mysql-workbench’ as the parameter :

root@hostname:/home/user/Downloads# apt-get install mysql-workbench
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-workbench : Depends: libctemplate2v5 but it is not going to be installed
                   Depends: libgdal.so.1-1.11.3
                   Depends: libgdal1i (>= 1.8.0) but it is not going to be installed
                   Depends: libmysqlcppconn7v5 but it is not going to be installed
                   Depends: libtinyxml2.6.2v5 but it is not going to be installed
                   Depends: libvsqlitepp3v5 (>= 0.3.13) but it is not going to be installed
                   Depends: mysql-workbench-data (= 6.3.6+dfsg-0ubuntu1) but it is not going to be installed
                   Depends: python-mysql.connector but it is not going to be installed
                   Depends: python-pyodbc (>= 2.1.8) but it is not going to be installed
                   Depends: python-pysqlite2 but it is not going to be installed
                   Recommends: mysql-utilities but it is not going to be installed
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

Either using the additional parameter ‘-f’ which is an additional paramter to actually force the installation :

root@hostname:/home/user/Downloads# apt-get -f install mysql-workbench
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-workbench : Depends: libctemplate2v5 but it is not going to be installed
                   Depends: libgdal.so.1-1.11.3
                   Depends: libgdal1i (>= 1.8.0) but it is not going to be installed
                   Depends: libmysqlcppconn7v5 but it is not going to be installed
                   Depends: libtinyxml2.6.2v5 but it is not going to be installed
                   Depends: libvsqlitepp3v5 (>= 0.3.13) but it is not going to be installed
                   Depends: mysql-workbench-data (= 6.3.6+dfsg-0ubuntu1) but it is not going to be installed
                   Depends: python-mysql.connector but it is not going to be installed
                   Depends: python-pyodbc (>= 2.1.8) but it is not going to be installed
                   Depends: python-pysqlite2 but it is not going to be installed
                   Recommends: mysql-utilities but it is not going to be installed
 mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
                             Depends: libhdf4-0-alt but it is not going to be installed
                             Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

Another installation for another package is also carried on for further execution :

root@hostname:/home/user/Downloads# apt-get install python-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package python-mysql
root@hostname:/home/user/Downloads# apt-get -f install libctemplate2v5
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
mysql-workbench-community : Depends: libgeos-c1v5 (>= 3.4.2) but it is not going to be installed
Depends: libhdf4-0-alt but it is not going to be installed
Depends: libnetcdf11 (>= 4.0.1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@hostname:/home/user/Downloads#

But actually, the correct step is after installing several package above is to install and to execute the following command :

root@hostname:/home/user/Downloads# apt-get -f install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Correcting dependencies... Done
The following additional packages will be installed:
  libaec0 libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libnetcdf11 libsz2
Suggested packages:
  libhdf4-doc libhdf4-alt-dev hdf4-tools libnetcdf4
The following NEW packages will be installed:
  libaec0 libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libnetcdf11 libsz2
0 upgraded, 7 newly installed, 0 to remove and 701 not upgraded.
1 not fully installed or removed.
Need to get 2.098 kB of archives.
After this operation, 7.973 kB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libgeos-3.5.0 amd64 3.5.0-1ubuntu2 [477 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libgeos-c1v5 amd64 3.5.0-1ubuntu2 [52,4 kB]
Get:3 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libhdf4-0-alt amd64 4.2.10-3.2 [264 kB]
Get:4 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libaec0 amd64 0.3.2-1 [18,0 kB]                                                                                                                                  
Get:5 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libsz2 amd64 0.3.2-1 [5.048 B]                                                                                                                                   
Get:6 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libhdf5-10 amd64 1.8.16+docs-4ubuntu1 [995 kB]                                                                                                                   
Get:7 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libnetcdf11 amd64 1:4.4.0-2 [286 kB]                                                                                                                             
Fetched 2.098 kB in 47s (44,2 kB/s)                                                                                                                                                                                              
Selecting previously unselected package libgeos-3.5.0.
(Reading database ... 904949 files and directories currently installed.)
Preparing to unpack .../libgeos-3.5.0_3.5.0-1ubuntu2_amd64.deb ...
Unpacking libgeos-3.5.0 (3.5.0-1ubuntu2) ...
Selecting previously unselected package libgeos-c1v5.
Preparing to unpack .../libgeos-c1v5_3.5.0-1ubuntu2_amd64.deb ...
Unpacking libgeos-c1v5 (3.5.0-1ubuntu2) ...
Selecting previously unselected package libhdf4-0-alt.
Preparing to unpack .../libhdf4-0-alt_4.2.10-3.2_amd64.deb ...
Unpacking libhdf4-0-alt (4.2.10-3.2) ...
Selecting previously unselected package libaec0:amd64.
Preparing to unpack .../libaec0_0.3.2-1_amd64.deb ...
Unpacking libaec0:amd64 (0.3.2-1) ...
Selecting previously unselected package libsz2:amd64.
Preparing to unpack .../libsz2_0.3.2-1_amd64.deb ...
Unpacking libsz2:amd64 (0.3.2-1) ...
Selecting previously unselected package libhdf5-10:amd64.
Preparing to unpack .../libhdf5-10_1.8.16+docs-4ubuntu1_amd64.deb ...
Unpacking libhdf5-10:amd64 (1.8.16+docs-4ubuntu1) ...
Selecting previously unselected package libnetcdf11.
Preparing to unpack .../libnetcdf11_1%3a4.4.0-2_amd64.deb ...
Unpacking libnetcdf11 (1:4.4.0-2) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
Setting up libgeos-3.5.0 (3.5.0-1ubuntu2) ...
Setting up libgeos-c1v5 (3.5.0-1ubuntu2) ...
Setting up libhdf4-0-alt (4.2.10-3.2) ...
Setting up libaec0:amd64 (0.3.2-1) ...
Setting up libsz2:amd64 (0.3.2-1) ...
Setting up libhdf5-10:amd64 (1.8.16+docs-4ubuntu1) ...
Setting up libnetcdf11 (1:4.4.0-2) ...
Setting up mysql-workbench-community (6.3.9-1ubuntu16.04) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
Processing triggers for menu (2.1.47ubuntu1) ...
root@hostname:/home/user/Downloads# 

The above command is forcing to install all the above package needed for installing MySQL Workbench further. The final execution of the MySQL Workbench installation :

root@hostname:/home/user/Downloads# apt-get -f install mysql-workbench
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libkmlbase1 libkmldom1 libkmlengine1 libminizip1 libmysqlcppconn7v5 libogdi3.2 libopenjp2-7 libproj9 libspatialite7
  libsuperlu4 libtinyxml2.6.2v5 liburiparser1 libvsqlitepp3v5 mysql-utilities mysql-workbench-data proj-bin proj-data python-mysql.connector python-pyodbc python-pysqlite2
Suggested packages:
  ogdi-bin python-pysqlite2-doc python-pysqlite2-dbg
The following NEW packages will be installed:
  libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libkmlbase1 libkmldom1 libkmlengine1 libminizip1 libmysqlcppconn7v5 libogdi3.2 libopenjp2-7 libproj9 libspatialite7
  libsuperlu4 libtinyxml2.6.2v5 liburiparser1 libvsqlitepp3v5 mysql-utilities mysql-workbench mysql-workbench-data proj-bin proj-data python-mysql.connector python-pyodbc python-pysqlite2
0 upgraded, 29 newly installed, 0 to remove and 701 not upgraded.
Need to get 21,7 MB of archives.
After this operation, 143 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libsuperlu4 amd64 4.3+dfsg-3 [158 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libarpack2 amd64 3.3.0-1build2 [88,2 kB]
Get:3 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libarmadillo6 amd64 1:6.500.5+dfsg-1 [75,2 kB]
Get:4 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libctemplate2v5 amd64 2.2-5ubuntu1 [144 kB]
Get:5 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libdap17v5 amd64 3.15.1-7 [412 kB]
Get:6 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libdapclient6v5 amd64 3.15.1-7 [85,3 kB]                                                                                                                         
Get:7 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libepsilon1 amd64 0.9.2-3ubuntu1 [41,0 kB]                                                                                                                       
Get:8 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libfreexl1 amd64 1.0.2-1 [33,6 kB]                                                                                                                               
Get:9 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libminizip1 amd64 1.1-8 [20,3 kB]                                                                                                                                
Get:10 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 liburiparser1 amd64 0.8.4-1 [38,0 kB]                                                                                                                           
Get:11 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libkmlbase1 amd64 1.3.0-1 [43,9 kB]                                                                                                                             
Get:12 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libkmldom1 amd64 1.3.0-1 [175 kB]                                                                                                                               
Get:13 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libkmlengine1 amd64 1.3.0-1 [77,1 kB]                                                                                                                           
Get:14 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 proj-data all 4.9.2-2 [4.004 kB]                                                                                                                                
Get:15 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libproj9 amd64 4.9.2-2 [143 kB]                                                                                                                                 
Get:16 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libogdi3.2 amd64 3.2.0~beta2-7.1build1 [212 kB]                                                                                                                 
Get:17 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 libopenjp2-7 amd64 2.1.0-2.1ubuntu0.1 [103 kB]                                                                                                          
Get:18 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libspatialite7 amd64 4.3.0a-5 [1.222 kB]                                                                                                                        
Get:19 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libgdal1i amd64 1.11.3+dfsg-3build2 [4.013 kB]                                                                                                                  
Get:19 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libgdal1i amd64 1.11.3+dfsg-3build2 [4.013 kB]                                                                                                                  
Get:20 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libmysqlcppconn7v5 amd64 1.1.7-0ubuntu1 [226 kB]                                                                                                                
Get:21 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libtinyxml2.6.2v5 amd64 2.6.2-3 [29,7 kB]                                                                                                                           
Get:22 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libvsqlitepp3v5 amd64 0.3.13-3.1 [43,5 kB]                                                                                                                      
Get:23 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 python-mysql.connector all 2.0.4-1 [86,9 kB]                                                                                                                    
Get:24 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 mysql-utilities all 1.6.1-2 [534 kB]                                                                                                                            
Get:25 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 mysql-workbench-data all 6.3.6+dfsg-0ubuntu1 [1.286 kB]                                                                                                         
Get:26 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 python-pyodbc amd64 3.0.7-0ubuntu2 [44,4 kB]                                                                                                                    
Get:27 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 python-pysqlite2 amd64 2.7.0-1 [34,1 kB]                                                                                                                        
Get:28 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 mysql-workbench amd64 6.3.6+dfsg-0ubuntu1 [8.287 kB]                                                                                                            
Get:29 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 proj-bin amd64 4.9.2-2 [31,3 kB]                                                                                                                                
Fetched 19,4 MB in 4min 45s (68,0 kB/s)                                                                                                                                                                                          
Selecting previously unselected package libsuperlu4:amd64.
(Reading database ... 905000 files and directories currently installed.)
Preparing to unpack .../libsuperlu4_4.3+dfsg-3_amd64.deb ...
Unpacking libsuperlu4:amd64 (4.3+dfsg-3) ...
Selecting previously unselected package libarpack2.
Preparing to unpack .../libarpack2_3.3.0-1build2_amd64.deb ...
Unpacking libarpack2 (3.3.0-1build2) ...
Selecting previously unselected package libarmadillo6.
Preparing to unpack .../libarmadillo6_1%3a6.500.5+dfsg-1_amd64.deb ...
Unpacking libarmadillo6 (1:6.500.5+dfsg-1) ...
Selecting previously unselected package libctemplate2v5.
Preparing to unpack .../libctemplate2v5_2.2-5ubuntu1_amd64.deb ...
Unpacking libctemplate2v5 (2.2-5ubuntu1) ...
Selecting previously unselected package libdap17v5:amd64.
Preparing to unpack .../libdap17v5_3.15.1-7_amd64.deb ...
Unpacking libdap17v5:amd64 (3.15.1-7) ...
Selecting previously unselected package libdapclient6v5:amd64.
Preparing to unpack .../libdapclient6v5_3.15.1-7_amd64.deb ...
Unpacking libdapclient6v5:amd64 (3.15.1-7) ...
Selecting previously unselected package libepsilon1:amd64.
Preparing to unpack .../libepsilon1_0.9.2-3ubuntu1_amd64.deb ...
Unpacking libepsilon1:amd64 (0.9.2-3ubuntu1) ...
Selecting previously unselected package libfreexl1:amd64.
Preparing to unpack .../libfreexl1_1.0.2-1_amd64.deb ...
Unpacking libfreexl1:amd64 (1.0.2-1) ...
Selecting previously unselected package libminizip1:amd64.
Preparing to unpack .../libminizip1_1.1-8_amd64.deb ...
Unpacking libminizip1:amd64 (1.1-8) ...
Selecting previously unselected package liburiparser1:amd64.
Preparing to unpack .../liburiparser1_0.8.4-1_amd64.deb ...
Unpacking liburiparser1:amd64 (0.8.4-1) ...
Selecting previously unselected package libkmlbase1:amd64.
Preparing to unpack .../libkmlbase1_1.3.0-1_amd64.deb ...
Unpacking libkmlbase1:amd64 (1.3.0-1) ...
Selecting previously unselected package libkmldom1:amd64.
Preparing to unpack .../libkmldom1_1.3.0-1_amd64.deb ...
Unpacking libkmldom1:amd64 (1.3.0-1) ...
Selecting previously unselected package libkmlengine1:amd64.
Preparing to unpack .../libkmlengine1_1.3.0-1_amd64.deb ...
Unpacking libkmlengine1:amd64 (1.3.0-1) ...
Selecting previously unselected package proj-data.
Preparing to unpack .../proj-data_4.9.2-2_all.deb ...
Unpacking proj-data (4.9.2-2) ...
Selecting previously unselected package libproj9.
Preparing to unpack .../libproj9_4.9.2-2_amd64.deb ...
Unpacking libproj9 (4.9.2-2) ...
Selecting previously unselected package libogdi3.2.
Preparing to unpack .../libogdi3.2_3.2.0~beta2-7.1build1_amd64.deb ...
Unpacking libogdi3.2 (3.2.0~beta2-7.1build1) ...
Selecting previously unselected package libopenjp2-7:amd64.
Preparing to unpack .../libopenjp2-7_2.1.0-2.1ubuntu0.1_amd64.deb ...
Unpacking libopenjp2-7:amd64 (2.1.0-2.1ubuntu0.1) ...
Selecting previously unselected package libspatialite7:amd64.
Preparing to unpack .../libspatialite7_4.3.0a-5_amd64.deb ...
Unpacking libspatialite7:amd64 (4.3.0a-5) ...
Selecting previously unselected package libgdal1i.
Preparing to unpack .../libgdal1i_1.11.3+dfsg-3build2_amd64.deb ...
Unpacking libgdal1i (1.11.3+dfsg-3build2) ...
Selecting previously unselected package libmysqlcppconn7v5.
Preparing to unpack .../libmysqlcppconn7v5_1.1.7-0ubuntu1_amd64.deb ...
Unpacking libmysqlcppconn7v5 (1.1.7-0ubuntu1) ...
Selecting previously unselected package libtinyxml2.6.2v5:amd64.
Preparing to unpack .../libtinyxml2.6.2v5_2.6.2-3_amd64.deb ...
Unpacking libtinyxml2.6.2v5:amd64 (2.6.2-3) ...
Selecting previously unselected package libvsqlitepp3v5:amd64.
Preparing to unpack .../libvsqlitepp3v5_0.3.13-3.1_amd64.deb ...
Unpacking libvsqlitepp3v5:amd64 (0.3.13-3.1) ...
Selecting previously unselected package python-mysql.connector.
Preparing to unpack .../python-mysql.connector_2.0.4-1_all.deb ...
Unpacking python-mysql.connector (2.0.4-1) ...
Selecting previously unselected package mysql-utilities.
Preparing to unpack .../mysql-utilities_1.6.1-2_all.deb ...
Unpacking mysql-utilities (1.6.1-2) ...
Selecting previously unselected package mysql-workbench-data.
Preparing to unpack .../mysql-workbench-data_6.3.6+dfsg-0ubuntu1_all.deb ...
Unpacking mysql-workbench-data (6.3.6+dfsg-0ubuntu1) ...
Replaced by files in installed package mysql-workbench-community (6.3.9-1ubuntu16.04) ...
Selecting previously unselected package python-pyodbc.
Preparing to unpack .../python-pyodbc_3.0.7-0ubuntu2_amd64.deb ...
Unpacking python-pyodbc (3.0.7-0ubuntu2) ...
Selecting previously unselected package python-pysqlite2.
Preparing to unpack .../python-pysqlite2_2.7.0-1_amd64.deb ...
Unpacking python-pysqlite2 (2.7.0-1) ...
Selecting previously unselected package mysql-workbench.
Preparing to unpack .../mysql-workbench_6.3.6+dfsg-0ubuntu1_amd64.deb ...
Unpacking mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Replaced by files in installed package mysql-workbench-community (6.3.9-1ubuntu16.04) ...
Selecting previously unselected package proj-bin.
Preparing to unpack .../proj-bin_4.9.2-2_amd64.deb ...
Unpacking proj-bin (4.9.2-2) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
Processing triggers for mime-support (3.59ubuntu1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu5) ...
Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
Unknown media type in type 'all/all'
Unknown media type in type 'all/allfiles'
Processing triggers for menu (2.1.47ubuntu1) ...
Setting up libsuperlu4:amd64 (4.3+dfsg-3) ...
Setting up libarpack2 (3.3.0-1build2) ...
Setting up libarmadillo6 (1:6.500.5+dfsg-1) ...
Setting up libctemplate2v5 (2.2-5ubuntu1) ...
Setting up libdap17v5:amd64 (3.15.1-7) ...
Setting up libdapclient6v5:amd64 (3.15.1-7) ...
Setting up libepsilon1:amd64 (0.9.2-3ubuntu1) ...
Setting up libfreexl1:amd64 (1.0.2-1) ...
Setting up libminizip1:amd64 (1.1-8) ...
Setting up liburiparser1:amd64 (0.8.4-1) ...
Setting up libkmlbase1:amd64 (1.3.0-1) ...
Setting up libkmldom1:amd64 (1.3.0-1) ...
Setting up libkmlengine1:amd64 (1.3.0-1) ...
Setting up proj-data (4.9.2-2) ...
Setting up libproj9 (4.9.2-2) ...
Setting up libogdi3.2 (3.2.0~beta2-7.1build1) ...
Setting up libopenjp2-7:amd64 (2.1.0-2.1ubuntu0.1) ...
Setting up libspatialite7:amd64 (4.3.0a-5) ...
Setting up libgdal1i (1.11.3+dfsg-3build2) ...
Setting up libmysqlcppconn7v5 (1.1.7-0ubuntu1) ...
Setting up libtinyxml2.6.2v5:amd64 (2.6.2-3) ...
Setting up libvsqlitepp3v5:amd64 (0.3.13-3.1) ...
Setting up python-mysql.connector (2.0.4-1) ...
Setting up mysql-utilities (1.6.1-2) ...
Setting up mysql-workbench-data (6.3.6+dfsg-0ubuntu1) ...
Setting up python-pyodbc (3.0.7-0ubuntu2) ...
Setting up python-pysqlite2 (2.7.0-1) ...
Setting up mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Setting up proj-bin (4.9.2-2) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
Processing triggers for menu (2.1.47ubuntu1) ...
You have new mail in /var/mail/root
root@hostname:/home/user/Downloads# 

Since the above execution successfully carried on, it means that MySQL Workbench has already been installed.

2 thoughts on “Install MySQL Workbench on Ubuntu 16.04 via Command Line

    1. Totally agree with you, I have wasted a lot of my time in order to fix the installation problem of MySQL Workbench on Ubuntu. Another proper solution might be installing MySQL Workbench in Microsoft Windows maybe ?. It might be a lot easier to do…
      If I have time to make the installation summary of it to make it a lot easier I’ll try to do it …, but currently my situation doesn’t meet that rquirement … I am so sorry…

      To show you that I have manage to install MySQL Workbench on Ubuntu, based on the article I have posted titled ‘How to generate ER Diagram from existing MySQL Database’ in this blog also, thankfully it is become useful.

Leave a Reply