MySQL Workbench is a user-friendly program supported by Oracle Corporation, designed for managing MySQL databases. It’s not just a database management tool; it also comes with extra features for working with MySQL databases. People like database administrators, architects, and developers often use it to visualize how their databases are structured.
This guide will show you how to install MySQL Workbench on Ubuntu 22.04. But here’s the catch: You need to have a MySQL server up and running on your system for it to work. If you don’t have one, don’t worry; we’ll guide you on setting it up. If you already have a MySQL server installed, you can skip that part and jump to the next section.
To install a MySQL server on Ubuntu 22.04, follow these step-by-step instructions:
Before installing MySQL server, it is recommended to update the system repositories. To do so, open the terminal and run the following commands:
sudo apt update
sudo apt upgrade
To install MySQL server on Ubuntu 22.04, run the following command in the terminal:
sudo apt install mysql-server
After installing MySQL server, verify its service status by running the following command:
sudo systemctl status mysql
If the service is running, you should see an output similar to the snapshot above.
To configure MySQL server, run the following command in the terminal:
This command will prompt you to set a root password and perform other security-related tasks.
Step 5: Log in to the MySQL server
To log in to the MySQL server, run the following command in the terminal:
sudo mysql -u root -p
You will be prompted to enter your root password.
To install MySQL Workbench on Ubuntu 22.04, run the following command in the terminal:
sudo snap install mysql-workbench-community
Next, choose “Applications” in the menu, locate the MySQL Workbench application, and open it:
This tutorial has shown you how to set up MySQL server on Ubuntu 22.04 and how to install MySQL Workbench. By following these steps, you should now have a working installation.
If you like the content, we would appreciate your support by buying us a coffee. Thank you so much for your visit and support.