Glam Prestige Journal

Bright entertainment trends with youth appeal.

MySQL Workbench is not supported with Ubuntu 20.04 LTS. Any solution for this?

2

7 Answers

MySQL has updated their repository for Focal Fossa and removed the repository for Eoan Ermine. To install MySQL Workbench on 20.04, either download the Workbench for 20.04 from MySQL archives or follow the alternate method mentioned below replacing eoan with focal.


Historical answer:

You can download the deb package for Eoan Ermine from MySQL archives and install that using:

sudo apt install ./mysql-workbench-community_8.0.19-1ubuntu19.10_amd64.deb

The dependencies of MySQL Workbench for 19.10 are satisfiable on 20.04. APT will ensure installation of the dependencies as well.

Alternatively, you can use MySQL's repository for 19.10 (Eoan Ermine) to get latest updates as soon as pushed in Eoan's repository or until MySQL starts supporting Focal Fossa. To add that:

  • Create a new file for MySQL repository:

    echo "deb eoan mysql-tools" | sudo tee /etc/apt/sources.list.d/mysql.list

    and run

    sudo apt update
  • You'll get an error, like

    Err:1 eoan InRelease The following signatures couldn't be verified because the public key is not available: NO_PUBKEY <some key value>
  • Add this key using

    sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys <key value>
  • Update and install MySQL

    sudo apt update
    sudo apt install mysql-workbench-community
3

What worked for me:

sudo snap install mysql-workbench-community
1

For anyone that comes here like I did by starting with a google search instead of going directly to the MySQL download page, there is a download explicitly for Ubuntu 20.04 on their downloads page:

enter image description here

MySQL has apt repository for ubuntu.

Download MySQL workbench repository config file from .

1) Install the downloaded repository config file.

sudo apt install ./mysql-apt-config_0.8.15-1_all.deb

2) Update apt package list.

sudo apt update

3) Install MySQL workbench. You will get latest from the repository.

sudo apt install mysql-workbench-community

Refer these links:

As suggested by @Tyler Collier, you can just visit the download page and install it. To make life easier, copy and paste the following commands in the terminal (for Ubuntu 20.10 only, although you can also change the link below next to wget command with the one you want for your ubuntu version. Installation links can be found here):

$ sudo apt-get install wget
$ mkdir /tmp/mysql_workbench_install && cd /tmp/mysql_workbench_install
$ wget #latest release (13-02-21)
$ sudo dpkg -i *

In case something went wrong, or couldn't finish installation due to lack of some dependencies, then:

$ sudo apt --fix-broken install

Cheers!

Unfortunately, the proposed solutions installing the .deb file at leads to depencies problems on Ubuntu 20.04.

To solve the problem, simply install the missing packages:

sudo apt install libpcrecpp0v5
sudo apt install libpython2.7
sudo apt install libzip5

Then it worked for me and I could connect to my remote MySQL database with the MySQL Workbench.

Addendum: I found the real reason of the problem: I had NO problem to use the updated workbench for Ubuntu 20.04 on a computer which was itself updated to Ubuntu 20.04 (in my case from Ubuntu 19.10). But on a NEW computer, which never saw Ubuntu in the past (i bought it 2 days ago and overwrote Windows with Ubuntu 20.04), these packages' dependencies were not satisfied and i had to install them. ;-)

Run this then reinstall the mysqlworkbench community

sudo apt --fix-broken install

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy