How To Install MySQL Workbench On Ubuntu

By bhagwatchouhan
How To Install MySQL Workbench On Ubuntu

MySQL Workbench is the Graphical Tool to manage the MySQL and MariaDB database servers. We can use Workbench to manage databases, database users, database tables. It also provides features to graphically design the database.

In this tutorial, we will discuss all the steps required to install MySQL Workbench on Ubuntu 18.04 LTS. The steps should be the same on other versions of Ubuntu.

Notes: You may also like to go through - How To Install MySQL 8 on Ubuntu.

 

Step 1: Refresh Packages List

Use the below-mentioned command to refresh the packages list. It will get the latest packages info from the ubuntu repositories so that we will install the most recent version of Workbench.

# Update packages list
sudo apt-get update

 

Step 2: Install Workbench

In this step, we will install Workbench using the command as mentioned below

# Install MySQL Workbench
sudo apt install mysql-workbench

Press Y to confirm and continue with the installation.

 

Step 3: Launch Workbench

Now launch the Workbench from the installed software as shown in Fig 1.

Launch Workbench

Fig 1

It will launch the Workbench and show the default window as shown in Fig 2.

Workbench Window

Fig 2

It shows the available MySQL servers installed on the system. If you have not installed a MySQL server, you can follow this tutorial: How to Install MySQL 8 on Ubuntu.

We can also launch the Workbench from the console using the below-mentioned command.

# Launch Workbench
mysql-workbench

 

Step 4: Configure Server

Click on the card with title Local Instance 3306. It will show the server details and button to connect MySQL Workbench with the installed MySQL or MariaDB server as shown in Fig 3.

Options to Connect with MySQL

Fig 3

Now click on the Connect Button. It might show a connection error, and you need to configure the MySQL root account to use the native password plugin, as mentioned in How to Install MySQL 8 on Ubuntu.

It will prompt for the password as shown in Fig 4.

Password Prompt

Fig 4

Enter the password and click on the OK Button. It will show the default layout as shown in Fig 5.

Default Workspace

Fig 5

This is how we can install MySQL Workbench on Ubuntu 18.04 LTS.

Share this blog:

Profile picture for user bhagwatchouhan
bhagwatchouhan