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:
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>
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:
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):
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. ;-)
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
withfocal
.Historical answer:
You can download the deb package for Eoan Ermine from MySQL archives and install that using:
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:
and run
You'll get an error, like
Add this key using
Update and install MySQL
What worked for me:
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/
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.
2) Update apt package list.
3) Install MySQL workbench. You will get latest from the repository.
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/
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):In case something went wrong, or couldn't finish installation due to lack of some dependencies, then:
Cheers!
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:
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