MySQL Workbench is a multi-platform GUI tool for interacting with MySQL relational databases. It offers a user-friendly interface for carrying out tasks involved with databases. It is used by developers, database admins for creation and modification of physical data model, SQL development, and server administration.
Here at Ibmi Media, we shall look into how to install MySQL workbench on Fedora Linux system.
Methods to install MySQL workbench on Fedora
- MySQL Installation from the YUM repository.
- MySQL Installation via snapd.
a. Steps to perform MySQL Installation from the YUM repository
1. Perform System Update
To begin, refresh Fedora's system repositories and update the packages with the below command:
$ sudo yum update
2. Download MySQL Workbench Yum Repository
MySQL is not available in the default Fedora OS repository. As such, it’s imperative that you install it before anything else.
So, head over to the MySQL downloads page and download the repo for Fedora.
For Fedora 32, run:
$ wget sudo dnf -y install https://dev.mysql.com/get/mysql80-community-release-fc32-1.noarch.rpm
For Fedora 33, run:
$ wget https://dev.mysql.com/get/mysql80-community-release-fc33-2.noarch.rpm
For Fedora 34, run:
$ wget https://dev.mysql.com/get/mysql80-community-release-fc34-2.noarch.rpm
For Fedora 35, run:
$ wget https://dev.mysql.com/get/mysql80-community-release-fc35-1.noarch.rpm
After the RPM file download, run the following command to install MySQL:
$ sudo rpm -Uvh mysql80-community-release-*
Next, install MySQL workbench with the command:
$ sudo yum install mysql-workbench
b. MySQL Installation from the YUM repository.
Alternatively, install MySQL Workbench on Fedora using snapd. As a requirement, confirm that you have snap enabled on Fedora
To install snapd, run the command:
$ sudo dnf install snapd
Then, enable snapd as follows:
$ sudo systemctl enable --now snapd.socket
After that, install MySQL workbench from snap store with the following command:
$ sudo snap install mysql-workbench-community
How to use MySQL Workbench ?
After the installation, launch MySQL workbench with the command:
This will display the MySQL Workbench welcome page.
- Next, connect to your database, you can either connect on localhost or another instance by clicking on + at the bottom left on your screen.
- If you are connecting to a local database, fill in the password.
- Then, the MYSQL workbench dashboard will pop up.
- On this dashboard, you can manage users and privilege, create schemas and even monitor database performance.
[Need help in fixing MySQL issues ? We can help you. ]