In this guide, we want to teach you How To Set up MySQL Workbench on AlmaLinux 8.
What is MySQL Workbench?
MySQL Workbench is a visual database modeling and designing tool capable of accessing MySQL databases on remote or on-site servers. It injects ease of use and functionality into your SQL and MySQL development projects. Furthermore, the tool offers a graphical interface to work with your on-site or remote databases.
The functionalities that you get are complete. But the popular ones are SQL designing, creating, developing, maintaining, and administering. Another essential function of the tool is to modify existing and supported databases using forward and reverse engineering.
Steps To Set up MySQL Workbench on AlmaLinux 8
To set up MySQL Workbench, you must log in to your server as a non-root user with sudo privileges. To do this, you can follow our guide the Initial Server Setup with AlmaLinux 8.
Now follow the steps below to complete this guide.
Install MySQL Workbench on AlmaLinux 8
By default, MySQL Workbench packages aren’t available in the default AlmaLinux repository. So you need to add it to your server.
To do this, run the following command:
sudo dnf install https://dev.mysql.com/get/mysql80-community-release-el8-3.noarch.rpm
When your installation is completed, run the system update that will refresh the repository cache to make sure the system will get the latest available packages from the added Repos.
sudo dnf update -y
At this point, you can use the following command to install MySQL Workbench on your server:
sudo dnf install mysql-workbench-community -y
Launch MySQL Workbench on AlmaLinux
Now, you can run the application by running the following command from your terminal:
Or you can go to the Application launcher, search for it and click when its icon appears.
Remove MySQL Workbench
If you no longer want to use Workbench, you can easily remove it with the command below:
sudo dnf remove mysql-workbench
Also, remove the repository:
sudo rm mysql-community.repo mysql-community-source.repo
That’s it, you are done.
For more information, you can visit the MySQL Workbench Documentation page.
At this point, you learn to Set up MySQL Workbench on AlmaLinux 8.
Hope you enjoy it.
You may be interested in these articles: