Pages

Monday, June 9, 2025

Install MySQL Workbench (Community Edition)

To See All Articles About Technology: Index of Lessons in Technology
(base) jain@jain-ThinkPad-T440s:~$ sudo apt install mysql-workbench
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package mysql-workbench

This error means mysql-workbench is not available in your default APT sources, which is common in some Ubuntu derivatives or if the required universe repository isn't enabled.


✅ Solution: Enable universe repository and update

Run the following commands:

bash
sudo add-apt-repository universe sudo apt update sudo apt install mysql-workbench

๐Ÿ›  If you're still getting errors

It's possible your system is:

  • Not Ubuntu (e.g., Linux Mint, MX Linux, or older version)

  • Or the MySQL Workbench version is not supported in the official repos

In that case, you can install Workbench via .deb package from MySQL’s official site.


✅ Manual Install (if APT fails)

1. Download .deb package from MySQL:

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

Select:

  • OS: Ubuntu/Linux DEB

  • Version: Match your Ubuntu version (e.g., 22.04)

2. Install downloaded .deb package:

Assuming the file is named mysql-workbench_*.deb:

bash
sudo dpkg -i mysql-workbench_*.deb sudo apt --fix-broken install

Let me know your Ubuntu version:

bash
lsb_release -a

I can then give you the exact .deb download link or instructions tailored to your distro.

(base) jain@jain-ThinkPad-T440s:~/Downloads$ sudo dpkg -i mysql-workbench-community_8.0.42-1ubuntu24.04_amd64.deb 
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 171412 files and directories currently installed.)
Preparing to unpack mysql-workbench-community_8.0.42-1ubuntu24.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.42-1ubuntu24.04) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libatkmm-1.6-1v5 (>= 2.28.4); however:
  Package libatkmm-1.6-1v5 is not installed.
 mysql-workbench-community depends on libglibmm-2.4-1t64 (>= 2.66.7); however:
  Package libglibmm-2.4-1t64 is not installed.
 mysql-workbench-community depends on libgtkmm-3.0-1t64 (>= 3.24.9); however:
  Package libgtkmm-3.0-1t64 is not installed.
 mysql-workbench-community depends on libmysqlclient21 (>= 8.0.11); however:
  Package libmysqlclient21 is not installed.
 mysql-workbench-community depends on libodbc2 (>= 2.3.1); however:
  Package libodbc2 is not installed.
 mysql-workbench-community depends on libproj25 (>= 9.4.0); however:
  Package libproj25 is not installed.
 mysql-workbench-community depends on libsigc++-2.0-0v5 (>= 2.8.0); however:
  Package libsigc++-2.0-0v5 is not installed.
 mysql-workbench-community depends on libzip4t64 (>= 0.10); however:
  Package libzip4t64 is not installed.

dpkg: error processing package mysql-workbench-community (--install):
 dependency problems - leaving unconfigured
Processing triggers for gnome-menus (3.36.0-1.1ubuntu3) ...
Processing triggers for desktop-file-utils (0.27-2build1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for shared-mime-info (2.4-4) ...
Errors were encountered while processing:
 mysql-workbench-community

You're almost there! The error you're seeing is due to missing dependencies required by the .deb package. Fortunately, this is common and can be easily fixed using APT.


✅ Fix MySQL Workbench Installation

After running dpkg, follow up with this command to automatically install all the missing dependencies:

bash
sudo apt --fix-broken install

This will:

  • Fetch and install all the missing packages required

  • Complete the installation of MySQL Workbench


๐Ÿงช Then (optional): Verify installation

You can launch MySQL Workbench via:

bash
mysql-workbench

Or search for it in your application menu.


๐Ÿ›  If --fix-broken doesn’t work

You can manually install all missing dependencies listed:

bash
sudo apt install libatkmm-1.6-1v5 libglibmm-2.4-1t64 libgtkmm-3.0-1t64 libmysqlclient21 libodbc2 libproj25 libsigc++-2.0-0v5 libzip4t64

Then re-run the .deb installer:

bash
sudo dpkg -i mysql-workbench-community_8.0.42-1ubuntu24.04_amd64.deb

Let me know if you'd prefer a lightweight MySQL GUI alternative (e.g., DBeaver, Beekeeper, or HeidiSQL via Wine).

Above debugging fixed my issues:

I ran the below three commands:

sudo dpkg -i mysql-workbench-community_8.0.42-1ubuntu24.04_amd64.deb 
sudo apt install libatkmm-1.6-1v5 libglibmm-2.4-1t64 libgtkmm-3.0-1t64 libmysqlclient21 libodbc2 libproj25 libsigc++-2.0-0v5 libzip4t64
sudo apt --fix-broken install
Tags: Technology,Database,

No comments:

Post a Comment