The MySQL Workbench is a GUI application that enables database administrators and Developers with administration, development, design, creation and maintenance of MySQL database systems. This tool is developed by same team that is behind MySQL relational database management system. In this short article we’re going to discuss on the installation of MySQL Workbench on Ubuntu 22.04|20.04 Desktop operating system.
MySQL Workbench is offered in the following Editions:
- MySQL Workbench Community Edition – This is an Open Source (GPL License) edition
- MySQL Workbench Standard Edition – Commercial, License required to operate
- MySQL Workbench Enterprise Edition – Commercial, License required
As a Developer, most features required for application design and integration with database are available in the Open Source edition. These features includes but are not limited to below.
- Visual SQL Development: You’ll get SQL Code Editor, Completion, Formatter, Syntax Highlighting, Code Generation, Snippets, and use of history.
- Visual Database Administration: You’ll be able to Stop/Start servers locally and remotely, View key server diagnostic information, View and parse slow and error logs, view and edit server settings, View and edit MySQL Replication settings.
- User and Session Management: Manage application roles, users and sessions from graphical interface.
- Data Management: Import and export, Quickly locate hard to find rows or cells and table Data Search.
- Connection Management: Configure connections to MySQL Servers and Configure SSH connections to local and remote servers.
- Visual Data Modeling: Auto Layout, Model Stored Procedures, Triggers, Functions, Model User Security and Auto Layout.
- Reverse Engineering from SQL Script and from Live Database.
- Schema Synchronization
- and many other features
Install MySQL Workbench on Ubuntu 22.04|20.04
This guide is geared towards the installation of MySQL Workbench Open source edition on Ubuntu Linux system. There is a MySQL repository for Focal Fossa that will be used for the installation of MySQL Workbench on Ubuntu 22.04|20.04.
The first step is to add the MySQL repository to your Ubuntu system. This can be quickly done by running the following commands in your terminal.
sudo apt update && sudo apt -y install wget
wget https://dev.mysql.com/get/mysql-apt-config_0.8.26-1_all.debConfirm the file has been downloaded locally.
$ ls -lh mysql-apt-config_0.8.26-1_all.deb
-rw-rw-r-- 1 jmutai jmutai 35K Feb 20 11:55 mysql-apt-config_0.8.26-1_all.debRun the installer script which will configure MySQL APT repository for you. For this you can use apt package manager or dpkg. I’m using apt as it can install any required dependencies without user interaction.
### Installation with dpkg ###
sudo dpkg -i mysql-apt-config_*_all.deb
### Installation with apt ###
sudo apt install ./mysql-apt-config_*_all.debWhen the execution is ongoing you’re asked to choose MySQL product that the repository will be configured for its installation. I recommend you select MySQL Server if you would like to install the Server packages later.
You can pick the version of MySQL in the installation screen. Please go with the latest version since the Client always have backward compatibly as opposed to using an older version which might miss features of recent releases.
Command installation output will be similar to below if the installation was successful.
Need to get 0 B/18.1 kB of archives.
After this operation, 35.8 kB of additional disk space will be used.
Get:1 /root/mysql-apt-config_0.8.26-1_all.deb mysql-apt-config all 0.8.26-1 [18.1 kB]
Preconfiguring packages ...
Selecting previously unselected package mysql-apt-config.
(Reading database ... 39223 files and directories currently installed.)
Preparing to unpack .../mysql-apt-config_0.8.26-1_all.deb ...
Unpacking mysql-apt-config (0.8.26-1) ...
Setting up mysql-apt-config (0.8.26-1) ...
Scanning processes...
Scanning linux images...You can now install MySQL Workbench on Ubuntu 22.04/20.04 with apt command. You can see we’re updating the package index before installation to ensure we’re pulling the package from the repository we added in the previous step.
sudo apt update
sudo apt install mysql-workbench-communityPress the y key to begin the installation of MySQL Workbench on Ubuntu.
....
The following NEW packages will be installed:
adwaita-icon-theme at-spi2-core dconf-gsettings-backend dconf-service fontconfig fontconfig-config fonts-dejavu-core gsettings-desktop-schemas gtk-update-icon-cache hicolor-icon-theme
humanity-icon-theme libatk-bridge2.0-0 libatk1.0-0 libatk1.0-data libatkmm-1.6-1v5 libatspi2.0-0 libavahi-client3 libavahi-common-data libavahi-common3 libcairo-gobject2 libcairo2
libcairomm-1.0-1v5 libcolord2 libcups2 libdatrie1 libdconf1 libdeflate0 libdrm-amdgpu1 libdrm-intel1 libdrm-nouveau2 libdrm-radeon1 libepoxy0 libfontconfig1 libgail-common libgail18
libgdk-pixbuf-2.0-0 libgdk-pixbuf2.0-bin libgdk-pixbuf2.0-common libgl1-amber-dri libgl1-mesa-dri libglapi-mesa libglibmm-2.4-1v5 libglvnd0 libglx-mesa0 libglx0 libgraphite2-3 libgtk-3-0
libgtk-3-bin libgtk-3-common libgtk2.0-0 libgtk2.0-bin libgtk2.0-common libgtkmm-3.0-1v5 libharfbuzz0b libjbig0 libjpeg-turbo8 libjpeg8 liblcms2-2 libllvm15 libmysqlclient21 libopengl0
libpango-1.0-0 libpangocairo-1.0-0 libpangoft2-1.0-0 libpangomm-1.4-1v5 libpciaccess0 libpcrecpp0v5 libpixman-1-0 libproj22 librsvg2-2 librsvg2-common libsecret-1-0 libsecret-common
libsensors-config libsensors5 libsigc++-2.0-0v5 libthai-data libthai0 libtiff5 libwayland-client0 libwayland-cursor0 libwayland-egl1 libwebp7 libx11-6 libx11-data libx11-xcb1 libxau6
libxcb-dri2-0 libxcb-dri3-0 libxcb-glx0 libxcb-present0 libxcb-randr0 libxcb-render0 libxcb-shm0 libxcb-sync1 libxcb-xfixes0 libxcb1 libxcomposite1 libxcursor1 libxdamage1 libxdmcp6 libxext6
libxfixes3 libxi6 libxinerama1 libxkbcommon0 libxrandr2 libxrender1 libxshmfence1 libxtst6 libxxf86vm1 libzip4 mysql-common mysql-community-client-plugins mysql-workbench-community proj-data
session-migration ubuntu-mono x11-common
0 upgraded, 119 newly installed, 0 to remove and 4 not upgraded.
Need to get 100 MB of archives.
After this operation, 426 MB of additional disk space will be used.
Do you want to continue? [Y/n] yUsing MySQL Workbench on Ubuntu 22.04/20.04
After installation launch MySQL Workbench on Ubuntu you can launch the application and connect your database server to begin management from a graphical interface.
You can connect as root user or database specific user with limited access and privileges.
If the connection is successful, you should be able to enjoy MySQL Workbench features. I recommend you go through the usage guides if this is the first time you’re using the tool.
Learning resources:
Installation on CentOS 8: How To Install MySQL Workbench on CentOS 8
More guides:
Setup Mail Server on CentOS 8 With Postfix, Dovecot, MySQL and RoundCube
Install RavenDB NoSQL database on Ubuntu
