How can I install MySQL Workbench on Ubuntu 20.04 LTS?

Question

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

Answer 1

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 http://repo.mysql.com/apt/ubuntu/ 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 http://repo.mysql.com/apt/ubuntu 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
  

Answer 2

What worked for me:

sudo snap install mysql-workbench-community

Answer 3

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:

https://dev.mysql.com/downloads/workbench/

Answer 4

MySQL has apt repository for ubuntu.

Download MySQL workbench repository config file from https://dev.mysql.com/downloads/repo/apt/ .

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:

https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

https://www.krizna.com/ubuntu/install-mysql-workbench-ubuntu-20-04/

Answer 5

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 https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community_8.0.23-1ubuntu20.10_amd64.deb #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!

Answer 6

Unfortunately, the proposed solutions installing the .deb file at https://dev.mysql.com/downloads/workbench/ 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. ;-)

Answer 7

Run this then reinstall the mysqlworkbench community

sudo apt --fix-broken install

Answer 8

To download MySQL-Workbench on Ubuntu 20.04, follow these steps:

1. Go to MySQL Workbench Archive
2. In the Product Version, choose an older version, like I selcted 8.0.29. MySQL-Workbench versions later than 8.0.29 are not available for Ubuntu 20.04. So, we need to select the old one.
3. Select Operating System as Ubuntu Linux

Then you will see the packages of MySQL-Workbench will appear for Ubuntu 20.04.