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.
https://dev.mysql.com/downloads/repo/apt/
You can ignore signup and download the .deb package directly from the above link.
Once the .deb package is downloaded , Go to downloads directory and install the package using debian package manager.
sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
Once the package is installed , Update the apt package repository.
sudo apt-get update
Now We need to install mysql-workbench-community package instead of mysql-workbench
sudo apt-get install mysql-workbench-community -y
Launching MySQL Workbench
After installation , MySQL Workbench can be launched in two ways.
We can use mysql-workbench command line utility or we can search for mysql-workbench software from the ubuntu software.
sudo mysql-workbench
Either ways , You should see the following screen.
Working with MySQL Workbench
With the help of workbench , We can connect to local or remote database server using password or SSH key based authentication.
For testing , I have installed and configured mysql on the local system.
To connect to it using the MySQL Workbench , We need to create Connections.
To create MySQL Connections , Click + icon
You should see the following screen.
Provide a Connection Name.
The connection method should be Standard (TCP/IP)
Under Parameters , For Hostname , Enter the database server IP address or the Endpoint.
For Port , 3306 , If you have configured mySQL with custom port , We can specify it there.
Provide the username and let the Default Scheme be Blank.
Click Test Connection , you will be prompted for the password of the user.
Enter the password and click OK.
You should see the following screen saying that the user is able to successfully make a connection with the MySQL database server.
Click OK and then click OK
We have successfully created a connection with the database using MySQL Workbench.
Double click the connection and you will be taken to the following page.
Click Schemas and you can see the list of database , the user was granted to access.
We can now manage the databases , run queries from the graphical interface.
To edit a Connection , Go to Home page , Right click on the Connection name and click Edit connection.
To delete a connection , Got to Home page , Right click on the connection name and click Delete Connection.
Conclusion
We have successfully installed MySQL Workbench on Ubuntu system.
Also we have learn to create and manage connections with the database servers.
Hope you find it helpful.
Please check my other publications.