How to Install MySQL WorkBench on Ubuntu?

MySQL Workbench is a feature-rich and popular graphical user interface (GUI) tool created by Oracle Corporation for MySQL database management. It offers a full array of tools for developers, architects, and database administrators to design, develop, and handle MySQL databases graphically. MySQL Workbench enables you to see database structures visually, execute SQL queries, manage users, and more, all through an easy-to-use graphical interface.

To work with MySQL Workbench, you must have a running MySQL server on your platform. If you have not yet installed a MySQL server, we will guide you through installing and configuring MySQL Workbench on Ubuntu 22.04, from the installation and configuration of the MySQL server to launching the Workbench application flawlessly.

Installation Steps for MySQL WorkBench on Ubuntu

Before the installation of MySQL Workbench, ensure that your system has MySQL server installed and running.

Step 1: Update Ubuntu System Packages

To update system repositories, type the following command on Ubuntu 22.04 in the terminal by using "CTRL+ALT+T". Updating ensures you receive the newest available software versions.

$ sudo apt update

Step 2: Install MySQL Server on Ubuntu 22.04

This command installs MySQL server along with necessary dependencies. So, Install the MySQL server on your PC using the following command in the next step.

 $ sudo apt-get install mysql-server

The installation of the MySQL server will be completed in a while, so wait with me for a while.

Step 3: Verify the MySQL service status

Check if the "MySQL" service is running properly

$ systemctl is-active mysql

The output indicates that the "MySQL" service is now operating on our Ubuntu 22.04 system and is active:

Step 4: Configure MySQL Server Setup

Now, type the command shown below to configure the MySQL server in its first, interactive configuration:

$ sudo mysql_secure_installation

You will be prompted to set the level for the password validation policy in the configuration manual. Choose a number from the drop-down menu based on your needs. Disable remote root login, and remove test databases. For better security, respond with Y (yes) to the prompts.

Step 5: The MySQL server, and log on.

Next, sign in to the MySQL server to choose "MySQL native password" as the default authentication method and provide a native root password:

$ sudo mysql

The error-free output of the following command shows that the MySQL server has been set up on our Ubuntu 22.04 machine, and we can proceed to install MySQL Workbench.

Installing MySQL Workbench on Ubuntu 22.04

We have completed all the requirements up to this point, and our Ubuntu 22.04 machine is now prepared for the installation of "MySQL Workbench." Run the following command in the terminal to accomplish this: 

Install MySQL Workbench Community using sudo aptitude

$ sudo snap install mysql-workbench-community

After that, select "Applications" from the menu, look for the MySQL workbench application, and then launch it:

Congratulations! The Ubuntu 22.04 system now has MySQL Workbench installed successfully. You can now visually manage your MySQL databases, run queries, design schemas, and more—all through an easy-to-use interface.

Why Use MySQL Workbench?

• Visual database design and modeling
• Run and test SQL queries with an intuitive interface
• Manage user accounts and permissions
• Monitor database performance
• Simplifies database management tasks

Conclusion

MySQL Workbench is a solid and intuitive platform for administering MySQL databases. It allows administrators and developers an easier way to work with their databases graphically. MySQL Workbench is a complete toolset that makes it simpler to work with your workflow whether you are designing intricate database schema, executing SQL queries, or handling user privileges.