In this blog post , We will learn how to install MySQL Workbench on Ubuntu.
We will also learn to configure MySQL Workbench , Create and manage connecctions.
In my previous blog post , I have explained in detail on how to install and configure MySQL on Ubuntu and how to manage MySQL users , databases , granting and revoking database access for the users.
Before installing MySQL Workbench on Ubuntu operating systems , Make sure you have sudo privileges.
What is MySQL Workbench?
MySQL Workbench is a graphical tool for working with MySQL servers and databases.
MySQL Workbench fully supports MySQL server versions 5.6 and higher. It is also compatible with older MySQL server 5.x versions, except in certain situations due to changed system tables.
It does not support MySQL server versions 4.x.
MySQL Workbench Functionalities
Server Administration :- Helps us to administer MySQL server instances for managing users , databases , performing backup and recovery , inspecting audit data , Check health of database , monitor server performance.
Data Modeling :- Helps us to create models of database scheme graphically.
Data Migration :- To migrate older version of MySQL to latest release.Also allows us to migrate other database servers such as SQL , PostgreSQL , SQLite data etc to MySQL .
SQL Development :- To create and manage connections to database servers.
MySQL Enterprise support :- Supports enterprise products such as MySQL Firewall , Audit and Enterprise backup.
MySQL Workbench Editions
MySQL Workbench comes in two editions.
Community Edition – Its is free of charge.
Commercial Edition
MySQL Workbench can be installed in Linux , Windows and MacOS.
Installing MySQL Workbench on Ubuntu
In the Ubuntu system , MySQL workbench packages comes with the default Ubuntu software package repository.
Update the APT package repository and install the MySQL workbench packages using the below command.
sudo apt-get update
sudo apt-get install mysql-workbench -y
The MySQL Workbench is successfully installed on the ubuntu system.
Installing MySQL Workbench Community Edition
To install the official MySQL Workbench , We need to install the official MySQL APT repository on the ubuntu system and then we can install the mysql workbench community edition.
APT package respository can be downloaded from the below link.