{"id":14068,"date":"2022-01-17T17:54:52","date_gmt":"2022-01-17T17:54:52","guid":{"rendered":"https:\/\/linuxways.net\/?p=14068"},"modified":"2022-01-18T18:32:20","modified_gmt":"2022-01-18T18:32:20","slug":"how-to-install-and-use-mysql-workbench-on-fedora-35-34-33-32","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/red-hat\/how-to-install-and-use-mysql-workbench-on-fedora-35-34-33-32\/","title":{"rendered":"How to Install and Use MySQL Workbench on Fedora 35\/34\/33\/32"},"content":{"rendered":"

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.<\/p>\n

This guide will take you through two approaches to install MySQL<\/p>\n

workbench on Fedora.<\/p>\n

Option 1: Install MySQL from the YUM repository<\/strong><\/h2>\n

To install MySQL from YUM repository, follow the steps below.<\/p>\n

Step 1: Update Fedora system<\/strong><\/h3>\n

Right off the bat, refresh Fedora\u2019s system repositories and update the packages<\/p>\n

$ sudo yum update<\/strong><\/pre>\n
Step 2: Download MySQL Workbench Yum Repository<\/strong><\/h3>\n
MySQL is not available in the default Fedora OS repository. As such, it\u2019s imperative that you install it before anything else.<\/p>\n
So, heav over to the MySQL downloads page<\/a> and download the repo for Fedora.<\/p>\n
For Fedora 32, run:<\/p>\n
$ wget sudo dnf -y install https:\/\/dev.mysql.com\/get\/mysql80-community-release-fc32-1.noarch.rpm<\/strong><\/pre>\n
For Fedora 33, run:<\/p>\n
$ wget https:\/\/dev.mysql.com\/get\/mysql80-community-release-fc33-2.noarch.rpm<\/strong><\/pre>\n
For Fedora 34, run:<\/p>\n
$ wget https:\/\/dev.mysql.com\/get\/mysql80-community-release-fc34-2.noarch.rpm<\/strong><\/pre>\n
For Fedora 35, run:<\/p>\n
$ wget <\/strong>https:\/\/dev.mysql.com\/get\/mysql80-community-release-fc35-1.noarch.rpm<\/strong><\/a><\/pre>\n
<\/strong><\/p>\n
After the RPM file download, run the following command to install MySQL.<\/p>\n
$ sudo rpm -Uvh mysql80-community-release-*<\/strong><\/pre>\n
<\/strong><\/p>\n
Next, install MySQL workbench with the command:<\/p>\n
$ sudo yum install mysql-workbench<\/strong><\/pre>\n
Option 2: Install using snapd<\/strong><\/h2>\n
Alternatively, install MySQL Workbench on Fedora using snapd. As a requirement, confirm that you have snap enabled on Fedora<\/p>\n
To install snapd, run the command:<\/p>\n
$ sudo dnf install snapd<\/strong><\/pre>\n
Then, enable snapd as follows:<\/p>\n
$ sudo systemctl enable --now snapd.socket<\/strong><\/pre>\n
After that, install MySQL workbench from snap store with the following command:<\/p>\n
$ sudo snap install mysql-workbench-community<\/strong><\/pre>\n
Using MySQL Workbench<\/strong><\/h2>\n
After the installation, launch MySQL workbench with the command:<\/p>\n
$ mysql-workbench<\/strong><\/pre>\n
You will see the following output:<\/p>\n
<\/strong><\/p>\n
Next, connect to your database, you can either connect on localhost or another instance by clicking on + at the bottom left on your screen. Provide the details as shown below.<\/p>\n
<\/strong><\/p>\n
If you are connecting to a local database, fill in the password.<\/p>\n
<\/strong><\/p>\n
The MYSQL workbench dashboard will pop up as demonstrated.<\/p>\n
<\/strong><\/p>\n
On this dashboard, you can manage users and privilege, create schemas and even monitor database performance.<\/p>\n
<\/strong><\/p>\n
Conclusion<\/strong><\/h2>\n
Now you can manage your SQL databases using MySQL workbench on Fedora.<\/p>","protected":false},"excerpt":{"rendered":"
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…<\/p>","protected":false},"author":1,"featured_media":14144,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[165],"tags":[857,856,826,831,27],"class_list":["post-14068","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-red-hat","tag-fedora-32","tag-fedora-33","tag-fedora-34","tag-fedora-35","tag-mysql"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/14068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=14068"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/14068\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/14144"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=14068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=14068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=14068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}