How To Install Mysql-Workbench On Linux Mint 20.2

To Install Mysql-Workbench on Linux Mint 20.2

Introduction:

MySQL Workbench is a Visual database designing and modeling access tool for MySQL server relational database. It facilitates creation of new physical data models and modification of existing MySQL databases with reverse/forward engineering and change management functions.

Step 1 : Check the OS version by using the below command

root@linuxhelp:~# lsb_release -a
No LSB modules are available.
Distributor ID:	Linuxmint
Description:	Linux Mint 20.2
Release:	20.2
Codename:	uma

Step 2 : Update the System repositories by using the below command

root@linuxhelp:~# apt-get update
Hit:1 http://repo.mysql.com/apt/ubuntu focal InRelease
Hit:2 http://archive.ubuntu.com/ubuntu focal InRelease                                                                             
Hit:3 http://archive.canonical.com/ubuntu focal InRelease                                                                          
Get:4 http://archive.ubuntu.com/ubuntu focal-updates InRelease [114 kB]                   
Get:5 http://security.ubuntu.com/ubuntu focal-security InRelease [114 kB]     
Ign:6 http://packages.linuxmint.com uma InRelease                                                           
Get:7 http://archive.ubuntu.com/ubuntu focal-backports InRelease [108 kB]  
Hit:8 http://packages.linuxmint.com uma Release          
Fetched 336 kB in 2s (174 kB/s)
Reading package lists... Done

Step 3 : reconfigure the mysql using dpkg command by using the below command

root@linuxhelp:~# dpkg-reconfigure mysql-apt-config
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK

Step 4 : Install the mysql-workbench package by using the below command

root@linuxhelp:~# apt-get install mysql-workbench-community
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  libopengl0 libpcrecpp0v5 libproj15 proj-data
Suggested packages:
  proj-bin libproj-dev
The following NEW packages will be installed:
  libopengl0 libpcrecpp0v5 libproj15 mysql-workbench-community proj-data
0 upgraded, 5 newly installed, 0 to remove and 28 not upgraded.
Need to get 38.0 MB of archives.
After this operation, 197 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://repo.mysql.com/apt/ubuntu focal/mysql-tools amd64 mysql-workbench-community amd64 8.0.27-1ubuntu20.04 [29.4 MB]
Get:2 http://archive.ubuntu.com/ubuntu focal/main amd64 libpcrecpp0v5 amd64 2:8.39-12build1 [15.5 kB]
Get:3 http://archive.ubuntu.com/ubuntu focal/universe amd64 proj-data all 6.3.1-1 [7,647 kB]
Get:4 http://archive.ubuntu.com/ubuntu focal/universe amd64 libproj15 amd64 6.3.1-1 [925 kB]
Get:5 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libopengl0 amd64 1.3.2-1~ubuntu0.20.04.1 [29.3 kB]
Fetched 38.0 MB in 4s (9,527 kB/s)                                                      

Selecting previously unselected package libpcrecpp0v5:amd64.
(Reading database ... 281386 files and directories currently installed.)
Preparing to unpack .../libpcrecpp0v5_2%3a8.39-12build1_amd64.deb ...
Unpacking libpcrecpp0v5:amd64 (2:8.39-12build1) ...
Selecting previously unselected package proj-data.
Preparing to unpack .../proj-data_6.3.1-1_all.deb ...
Unpacking proj-data (6.3.1-1) ...
Selecting previously unselected package libproj15:amd64.
Preparing to unpack .../libproj15_6.3.1-1_amd64.deb ...
Unpacking libproj15:amd64 (6.3.1-1) ...
Selecting previously unselected package libopengl0:amd64.
Preparing to unpack .../libopengl0_1.3.2-1~ubuntu0.20.04.1_amd64.deb ...
Unpacking libopengl0:amd64 (1.3.2-1~ubuntu0.20.04.1) ...
Selecting previously unselected package mysql-workbench-community.
Preparing to unpack .../mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb ...
Unpacking mysql-workbench-community (8.0.27-1ubuntu20.04) ...
Setting up libpcrecpp0v5:amd64 (2:8.39-12build1) ...
Setting up proj-data (6.3.1-1) ...
Setting up libopengl0:amd64 (1.3.2-1~ubuntu0.20.04.1) ...
Setting up libproj15:amd64 (6.3.1-1) ...
Setting up mysql-workbench-community (8.0.27-1ubuntu20.04) ...
Processing triggers for mime-support (3.64ubuntu1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
Processing triggers for shared-mime-info (1.15-1) ...
Processing triggers for desktop-file-utils (0.24+linuxmint1) ...

Step 5: To Open the menubar and search mysql workbench as shown in the below image

Step 6: This is the welcome page of mysql workbench

Step 7: This image shows the connection setup option. Step 8: This is the image shows the manage server Connections

With this, the installation process of MySQL-workbench on Linux mint 20.2 comes to an end !!

FAQ
Q
How will you open mysql-workbench in the command line?
A
To open mysql-workbench in the command line by using the mysql-workbench command.
Q
In which area can you search for mysql-workbench?
A
We search mysql-workbench in the Menu area.
Q
How will you install mysql-workbench package?
A
To install mysql-workbench package use apt-get install mysql-workbench-community
Q
What is the dpkg command for configuring the MySQL server?
A
The dpkg command for configuring the MySQL server is dpkg-reconfigurre mysql-apt-config
Q
What is the command line for updating the system repositories?
A
To update the system repositories by using the command apt-get update