Installing a database GUI should not begin by hunting for an old .deb filename. The earlier version of this guide pinned MySQL Workbench 8.0.27 and libzip5 for Ubuntu 20.04; both details age badly and can force incompatible libraries onto a newer system. The maintainable route is Oracle’s MySQL APT repository, provided your Ubuntu release is currently listed as supported.

Check Ubuntu and CPU architecture first

Terminalbash
. /etc/os-release
printf 'Ubuntu: %s (%s)\n' "$PRETTY_NAME" "$VERSION_CODENAME"
dpkg --print-architecture

Read the result before downloading

  • /etc/os-release is the system’s authoritative distribution metadata; VERSION_CODENAME identifies the repository suite.

  • dpkg --print-architecture reports the package architecture, commonly amd64 on Intel/AMD PCs.

  • Match both values against Oracle’s current download and supported-platform pages. A package built for a different Ubuntu release may install yet fail at runtime.

  • Do not copy the old libzip5 command into a modern release. Let APT resolve dependencies declared by the current package.

Choose an installation source deliberately

  • Oracle MySQL APT repository: provides the MySQL Release team’s current package, named mysql-workbench-community. This is the route documented below.

  • Ubuntu repository: when available for your Ubuntu release, its community-maintained package is typically named mysql-workbench and may trail Oracle’s build.

  • Direct Oracle `.deb`: workable for a one-off install, but upgrades and dependencies are cleaner through a configured repository.

  • Snap/Flatpak or third-party PPA: use only after evaluating publisher identity, confinement, update ownership, and organizational policy; those are not Oracle’s documented DEB route.

1. Download and verify the MySQL APT setup package

Open Oracle’s official MySQL APT Repository download page, select the current architecture-independent mysql-apt-config DEB, and save it in Downloads. Oracle may offer a “No thanks, just start my download” link. Record the filename and checksum shown on the download page instead of reusing a version from this article.

~/Downloadsbash
ls -lh mysql-apt-config_*_all.deb
sha256sum mysql-apt-config_*_all.deb

Why inspect the download

  • The filename glob should resolve to the single setup package you just downloaded; remove or move older copies if it matches more than one.

  • sha256sum computes a content fingerprint. Compare it with an HTTPS-published SHA-256 value when Oracle supplies one; Oracle’s page also publishes package integrity information.

  • A checksum detects corruption or substitution only when the expected value comes from a trusted independent page.

  • The repository setup package configures APT sources and signing trust; treat it as privileged software, not as an ordinary document.

2. Add Oracle’s repository configuration

~/Downloadsbash
sudo dpkg -i ./mysql-apt-config_*_all.deb

Risk level: caution. Review the command before running it.

What this changes

  • dpkg -i installs the local repository-configuration package with root privileges. Review the exact file matched by the glob before pressing Enter.

  • The interactive screen lets you select product tracks. Workbench is supplied through the repository’s tools component; avoid changing an existing MySQL Server release series unless that migration is intentional.

  • Repository selection affects future upgrades for MySQL components, not just today’s GUI install.

  • If the setup menu offers no entry for your Ubuntu codename, stop rather than forcing a different distribution suite.

3. Refresh metadata and inspect the candidate

Terminalbash
sudo apt update
apt-cache policy mysql-workbench-community

Verify before installing

  • apt update downloads signed repository metadata; signature or codename errors must be fixed rather than bypassed.

  • apt-cache policy shows the candidate version and repository origin without installing it.

  • The candidate should come from Oracle’s configured MySQL repository when you intend to use the community package.

  • If no candidate appears, reopen the repository configurator or inspect /etc/apt/sources.list.d/mysql.list; do not install a random package from a search result.

4. Install MySQL Workbench

Terminalbash
sudo apt install mysql-workbench-community

Risk level: caution. Review the command before running it.

What APT handles for you

  • APT resolves the current dependency set for the selected Ubuntu release; manually installing the legacy libzip5 package is neither required nor safe advice.

  • Read the package, version, download size, and disk-space summary before confirming.

  • The command installs the graphical client and supporting files, not a database server or production schema.

  • Future apt upgrade runs can update Workbench through the same trusted repository.

5. Verify and launch the application

Terminalbash
mysql-workbench --version
mysql-workbench

What successful verification proves

  • --version proves the executable is on PATH and records the build for a support request.

  • Launching from a terminal keeps diagnostic messages visible; use the desktop application launcher after the first clean start.

  • Workbench settings and rotating logs live under ~/.mysql/workbench/ on Linux, which is useful when the GUI exits without a useful dialog.

  • A successful launch does not prove database connectivity; that requires a separate connection test.

Connect to a local or remote MySQL server

  • Select the + beside MySQL Connections and give the connection a descriptive name such as Local development or Staging read-only.

  • Use 127.0.0.1 for a TCP connection to a local server, commonly on port 3306; localhost may select different transport behavior in some client stacks.

  • For a remote server, prefer Standard TCP/IP over SSH or an approved VPN/bastion. Do not expose port 3306 broadly to the internet.

  • Choose Test Connection before saving. Store credentials in the desktop keyring only on a trusted, encrypted workstation.

  • Use a least-privilege MySQL account. Administrative credentials should not become the default connection for routine queries.

Troubleshooting installation and startup

  • Package has no installation candidate: confirm Oracle supports the Ubuntu codename, enable the tools component, run apt update, and inspect apt-cache policy.

  • Unmet dependencies: ensure the package matches the OS release and architecture, then let sudo apt --fix-broken install repair a genuinely interrupted APT transaction; do not fetch individual libraries from abandoned releases.

  • Repository signature failure: confirm system time, HTTPS access, repository package currency, and signing configuration. Never add --allow-unauthenticated.

  • Workbench opens but cannot connect: distinguish network reachability, server listening address, firewall, TLS, account host grants, and authentication failures. The GUI installation may be completely healthy.

  • Password vault fails: Oracle documents gnome-keyring-daemon for vault storage on Linux; ensure the desktop keyring is installed, unlocked, and integrated.

  • GUI crashes: launch from a terminal, inspect the newest ~/.mysql/workbench/wb.log, record the version, and check Oracle’s bug database before deleting the whole profile.

Remove Workbench without removing your databases

Terminalbash
sudo apt remove mysql-workbench-community
sudo apt autoremove

Risk level: caution. Review the command before running it.

Understand the cleanup boundary

  • apt remove uninstalls the Workbench package but generally retains package configuration; purge removes package-managed configuration too.

  • Review the autoremove proposal carefully before confirmation because it removes dependencies APT considers unused.

  • Removing Workbench does not delete schemas hosted by a separate MySQL server, but local connection profiles and cached GUI state are a separate concern.

  • The Oracle repository remains configured until you intentionally remove its setup package/source; do not remove server repositories casually on a machine that also hosts MySQL.

Primary references