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
$ 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) ...
$ 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
(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) ...
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:
faied@faied-VirtualBox:~/Downloads$ sudo dpkg -i mysql-workbench-community_8.0.36-1ubuntu22.04_amd64.deb
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 190471 files and directories currently installed.)
Preparing to unpack mysql-workbench-community_8.0.36-1ubuntu22.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.36-1ubuntu22.04) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
mysql-workbench-community depends on libatkmm-1.6-1v5 (>= 2.28.2); however:
Version of libatkmm-1.6-1v5:amd64 on system is 2.28.0-2build1.
mysql-workbench-community depends on libc6 (>= 2.35); however:
Version of libc6:amd64 on system is 2.31-0ubuntu9.15.
mysql-workbench-community depends on libdeflate0 (>= 1.0); however:
Package libdeflate0 is not installed.
mysql-workbench-community depends on libgdk-pixbuf-2.0-0 (>= 2.22.0); however:
Package libgdk-pixbuf-2.0-0 is not installed.
mysql-workbench-community depends on libglib2.0-0 (>= 2.70.0); however:
Version of libglib2.0-0:amd64 on system is 2.64.6-1~ubuntu20.04.6.
mysql-workbench-community depends on libglibmm-2.4-1v5 (>= 2.66.2); however:
Version of libglibmm-2.4-1v5:amd64 on system is 2.64.2-1.
mysql-workbench-community depends on libgtkmm-3.0-1v5 (>= 3.24.5); however:
Version of libgtkmm-3.0-1v5:amd64 on system is 3.24.2-1build1.
mysql-workbench-community depends on libproj22 (>= 8.2.0); however:
Package libproj22 is not installed.
mysql-workbench-community depends on libpython3.10 (>= 3.10.0); however:
Package libpython3.10 is not installed.
mysql-workbench-community depends on libsasl2-2 (>= 2.1.27+dfsg2); however:
Version of libsasl2-2:amd64 on system is 2.1.27+dfsg-2ubuntu0.1.
mysql-workbench-community depends on libssl3 (>= 3.0.0~~alpha1); however:
Package libssl3 is not installed.
mysql-workbench-community depends on libstdc++6 (>= 12); however:
Version of libstdc++6:amd64 on system is 10.5.0-1ubuntu1~20.04.
mysql-workbench-community depends on libzip4 (>= 0.10); however:
Package libzip4 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
faied@faied-VirtualBox:~/Downloads$ sudo apt --fix-broken install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
gir1.2-goa-1.0 libfwupdplugin1 libllvm11 libxmlb1
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
mysql-workbench-community
0 upgraded, 0 newly installed, 1 to remove and 113 not upgraded.
1 not fully installed or removed.
After this operation, 123 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 191755 files and directories currently installed.)
Removing mysql-workbench-community (8.0.36-1ubuntu22.04) ...
Processing triggers for mime-support (3.64ubuntu1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
Processing triggers for shared-mime-info (1.15-1) ...
Processing triggers for desktop-file-utils (0.24-1ubuntu3) ...
i got the same promlem as you get, but in my case the prolem couldn't solve.
please help me
Hi faeid. Not sure if you've managed to resolve the issue by now but have you considered running MySQL Workbench as a Docker container? This way you don't need to worry about installing dependencies. https://hub.docker.com/r/linuxserver/mysql-workbench
Post a Comment