How to Install MySQL Workbench on Ubuntu Linux
In few recent post we saw how we install and work on MySQL. During that time, i received some review that how we can install MySQL Workbench on Linux/Unix machine and further connect on MySQL machine, to work through Workbench
So in this post we will try to install MySQL Workbench on Ubuntu 20.04 Machine. On various Linux/Unix Machine installation of workbench steps are almost same in regard to download it and install from package manager.
What is MySQL Workbench
Why we need MYSQL Workbench and what is relevance of it for any MySQL User. Actually this is graphical User-interface that provide connectivity to MySQL Server and allow to work on MySQL database. This interface has nice graphical user-interface with wide variety features with visual SQL development, visual DB administration, connection management, visual data modeling, database views, database migration tools.
It has various editions standard, enterprise and community. Community editions is open-Source and free to use for personal and education purpose.
In this post we have Ubuntu machine 20.04 latest as of July 2020.
# lsb_release -d Description: Ubuntu 20.04 LTS # uname -r 5.4.0-40-generic # mysql --version mysql Ver 8.0.21 for Linux on x86_64 (MySQL Community Server - GPL)
For your Linux/Unix Machine we have to add repositories through packages available through Oracle Website .
Select you operating system type from here and download package and install. In this we download mysql-apt-config_0.8.15-1_all.deb
Install package with suitable package manager. like to Ubuntu.
For Ubuntu Machines $ sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb For RhEL/CentOS/Fedora Machines # rpm -ivh
Like in case Ubuntu Machine we will get below Output during installation steps. it will ask for some user inputs.
In above, we could see what all packages will install during installation and how much space will carried out in this installation for it, we need to agree with it and press Y on console for it
After this we need to select OK on Terminal user-interface and select OK for next options. further it will install with default configuration of MySQL-workbench.
Further we can able to run /usr/bin/mysql-workbench to open MySQL-workbench or through Ubuntu application menu.