{"id":13895,"date":"2022-09-08T23:22:18","date_gmt":"2022-09-08T20:22:18","guid":{"rendered":"https:\/\/kifarunix.com\/?p=13895"},"modified":"2024-03-09T21:28:59","modified_gmt":"2024-03-09T18:28:59","slug":"install-mysql-workbench-on-oracle-linux","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-mysql-workbench-on-oracle-linux\/","title":{"rendered":"Install MySQL Workbench on Oracle Linux 8"},"content":{"rendered":"\n<p>In this tutorial, you will learn how to install MySQL Workbench on Oracle Linux 8. <a href=\"https:\/\/dev.mysql.com\/doc\/workbench\/en\/wb-intro.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Workbench<\/a> is graphical user interface tool that is used by GUI centric database administrators\/architects\/developers to administer and manage MySQL servers and databases. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Install MySQL Workbench on Oracle Linux 8<\/h2>\n\n\n\n<p>MySQL Workbench is a GUI based tool. It therefore means that you need to have a desktop environment installed.<\/p>\n\n\n\n<p>In this tutorial, we are installing MySQL Workbench on Oracle Linux 8 Desktop.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Install MySQL YUM Repository on Oracle Linux 8<\/h3>\n\n\n\n<p>The <a href=\"https:\/\/dev.mysql.com\/downloads\/repo\/yum\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Yum repository<\/a> provides the latest version of MySQL Workbench. You can install  the repo by executing the command below (ensure you download the current version of the repo rpm from the repository downloads page).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf install https:\/\/repo.mysql.com\/\/mysql80-community-release-el8-4.noarch.rpm<\/code><\/pre>\n\n\n\n<p>Sample installation output;<\/p>\n\n\n\n<pre class=\"scroll-box\"><code>\nmysql80-community-release-el8-4.noarch.rpm       11 kB\/s |  14 kB     00:01    \nDependencies resolved.\n================================================================================\n Package                        Arch        Version     Repository         Size\n================================================================================\nInstalling:\n mysql80-community-release      noarch      el8-4       @commandline       14 k\n\nTransaction Summary\n================================================================================\nInstall  1 Package\n\nTotal size: 14 k\nInstalled size: 8.6 k\nIs this ok [y\/N]: y\nDownloading Packages:\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n  Preparing        :                                                        1\/1 \n  Installing       : mysql80-community-release-el8-4.noarch                 1\/1 \n  Verifying        : mysql80-community-release-el8-4.noarch                 1\/1 \n\nInstalled:\n  mysql80-community-release-el8-4.noarch                                        \n\nComplete!\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Installing MySQL Workbench on Oracle Linux 8<\/h3>\n\n\n\n<p>Once the repository is in place, you can now install MySQL Workbench on Oracle Linux using the command below;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf install mysql-workbench-community<\/code><\/pre>\n\n\n\n<pre class=\"scroll-box\"><code>\nMySQL 8.0 Community Server                                                                                                                  780 kB\/s | 2.3 MB     00:03    \nMySQL Connectors Community                                                                                                                   89 kB\/s |  79 kB     00:00    \nMySQL Tools Community                                                                                                                       311 kB\/s | 521 kB     00:01    \nDependencies resolved.\n============================================================================================================================================================================\n Package                                    Architecture            Version                                                    Repository                              Size\n============================================================================================================================================================================\nInstalling:\n mysql-workbench-community                  x86_64                  8.0.30-1.el8                                               mysql-tools-community                   40 M\nInstalling dependencies:\n libglvnd-opengl                            x86_64                  1:1.3.4-1.el8                                              ol8_appstream                           47 k\n libzip                                     x86_64                  1.5.1-2.module+el8.2.0+5510+6771133c                       ol8_appstream                           63 k\n pcre-cpp                                   x86_64                  8.42-6.el8                                                 ol8_baseos_latest                       47 k\n proj                                       x86_64                  6.3.2-4.el8                                                ol8_developer_EPEL                     2.0 M\n proj-datumgrid                             noarch                  1.8-6.3.2.4.el8                                            ol8_developer_EPEL                     5.4 M\n python38-libs                              x86_64                  3.8.12-1.module+el8.6.0+20556+9910889d                     ol8_appstream                          8.3 M\n python38-pip-wheel                         noarch                  19.3.1-5.module+el8.6.0+20556+9910889d                     ol8_appstream                          1.0 M\n python38-setuptools-wheel                  noarch                  41.6.0-5.module+el8.5.0+20371+4f24d723                     ol8_appstream                          304 k\nEnabling module streams:\n httpd                                                              2.4                                                                                                    \n nginx                                                              1.14                                                                                                   \n php                                                                7.2                                                                                                    \n python38                                                           3.8                                                                                                    \n\nTransaction Summary\n============================================================================================================================================================================\nInstall  9 Packages\n\nTotal download size: 58 M\nInstalled size: 266 M\nIs this ok [y\/N]: y\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Running MySQL Workbench on Oracle Linux<\/h3>\n\n\n\n<p>Once the installation is done, you can launch MySQL Workbench from your applications menu;<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/launch-mysql-workbench-oracle-linux.png\" class=\"td-modal-image\"><figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"889\" height=\"299\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/launch-mysql-workbench-oracle-linux.png\" alt=\"Install MySQL Workbench on Oracle Linux 8\" class=\"wp-image-13966\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/launch-mysql-workbench-oracle-linux.png?v=1662668071 889w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/launch-mysql-workbench-oracle-linux-768x258.png?v=1662668071 768w\" sizes=\"(max-width: 889px) 100vw, 889px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>Or from the command line by running;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql-workbench<\/code><\/pre>\n\n\n\n<p>When launched, this is the default interface;<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-gui.png\" class=\"td-modal-image\"><figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1172\" height=\"715\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-gui.png\" alt=\"Install MySQL Workbench on Oracle Linux 8\" class=\"wp-image-13968\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-gui.png?v=1662668108 1172w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-gui-768x469.png?v=1662668108 768w\" sizes=\"(max-width: 1172px) 100vw, 1172px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>You can go through the menu for various MySQL Workbench options.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Connecting MySQL Workbench to a Database<\/h3>\n\n\n\n<p>To connect to a database from MySQL Workbench, you can navigate to <strong>menu &gt; Databases &gt; Manage connections &gt; New<\/strong>.<\/p>\n\n\n\n<p>Or simply from welcome page, press <strong>MySQL Connections +<\/strong><\/p>\n\n\n\n<p>On the new database connection setting Wizard;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set the name of the connection<\/li>\n\n\n\n<li>Choose a connection method;<\/li>\n\n\n\n<li>Set the connection parameters;\n<ul class=\"wp-block-list\">\n<li>Hostname (IP or resolvable name)<\/li>\n\n\n\n<li>Port<\/li>\n\n\n\n<li>Username<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Under SSL, enter the appropriate settings if your DB requires SSL to connect to.<\/li>\n\n\n\n<li>Check other settings under Advanced!<\/li>\n<\/ul>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database-connection.png\" class=\"td-modal-image\"><figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1173\" height=\"807\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database-connection.png\" alt=\"Install MySQL Workbench on Oracle Linux 8\" class=\"wp-image-13969\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database-connection.png?v=1662668135 1173w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database-connection-768x528.png?v=1662668135 768w\" sizes=\"(max-width: 1173px) 100vw, 1173px\" \/><\/figure><\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next Click <strong>Test Connection<\/strong>.\n<ul class=\"wp-block-list\">\n<li>Enter the password<\/li>\n\n\n\n<li>Confirm the connection<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/test-database-connection.png\" class=\"td-modal-image\"><figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1172\" height=\"806\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/test-database-connection.png\" alt=\"Install MySQL Workbench on Oracle Linux 8\" class=\"wp-image-13970\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/test-database-connection.png?v=1662668157 1172w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/test-database-connection-768x528.png?v=1662668157 768w\" sizes=\"(max-width: 1172px) 100vw, 1172px\" \/><\/figure><\/a><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click Ok to add the connection.<\/li>\n\n\n\n<li>The connection now appears on the workbench interface;<\/li>\n<\/ul>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database_connections.png\" class=\"td-modal-image\"><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1170\" height=\"774\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database_connections.png\" alt=\"Install MySQL Workbench on Oracle Linux 8\" class=\"wp-image-13967\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database_connections.png?v=1662668093 1170w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/database_connections-768x508.png?v=1662668093 768w\" sizes=\"(max-width: 1170px) 100vw, 1170px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>You can double click on the connection to connect to the database;<\/p>\n\n\n\n<div><a href=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-execute-queries.png\" class=\"td-modal-image\"><figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1025\" height=\"716\" src=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-execute-queries.png\" alt=\"Install MySQL Workbench on Oracle Linux 8\" class=\"wp-image-13971\" title=\"\" srcset=\"https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-execute-queries.png?v=1662668204 1025w, https:\/\/kifarunix.com\/wp-content\/uploads\/2022\/09\/mysql-workbench-execute-queries-768x536.png?v=1662668204 768w\" sizes=\"(max-width: 1025px) 100vw, 1025px\" \/><\/figure><\/a><\/div>\n\n\n\n<p>And that is it on installing MySQL Workbench on Oracle Linux 8.<\/p>\n\n\n\n<p>Read more on the <a href=\"https:\/\/dev.mysql.com\/doc\/workbench\/en\/wb-configuring.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Workbench documentation page.<\/a><\/p>\n\n\n\n<p>Other Tutorials;<\/p>\n\n\n\n<p><a href=\"https:\/\/kifarunix.com\/install-mysql-8-on-oracle-linux\/\" target=\"_blank\" rel=\"noreferrer noopener\">Install MySQL 8 on Oracle Linux 9<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/kifarunix.com\/install-mysql-8-on-ubuntu\/\" target=\"_blank\" rel=\"noreferrer noopener\">Install MySQL 8 on Ubuntu 22.04<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/kifarunix.com\/configure-guacamole-mysql-database-authentication\/\" target=\"_blank\" rel=\"noreferrer noopener\">Configure Guacamole MySQL Database Authentication<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to install MySQL Workbench on Oracle Linux 8. MySQL Workbench is graphical user interface tool that is used<\/p>\n","protected":false},"author":1,"featured_media":13973,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[121,299,929],"tags":[5779,5783,135,5782,5746,5781,5780],"class_list":["post-13895","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos","category-database","category-mysql","tag-install-mysql-workbench-on-oracle-linux-8","tag-install-workbench-on-oracle-linux","tag-mysql","tag-mysql-workbench","tag-oracle-linux","tag-oracle-linux-workbench","tag-workbench-mysql-oracle-linux","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/13895"}],"collection":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/comments?post=13895"}],"version-history":[{"count":11,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/13895\/revisions"}],"predecessor-version":[{"id":20621,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/13895\/revisions\/20621"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media\/13973"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=13895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=13895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=13895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}