{"id":2942,"date":"2020-03-28T10:15:00","date_gmt":"2020-03-28T04:45:00","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=2942"},"modified":"2020-03-28T04:14:23","modified_gmt":"2020-03-27T22:44:23","slug":"install-and-configure-mysql-workbench-on-ubuntu-linux","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/","title":{"rendered":"Install and Configure MySQL Workbench on Ubuntu Linux"},"content":{"rendered":"\n<p>MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on Ubuntu 18.04 (Bionic Beaver).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>In this tutorial you will learn:<\/strong> <\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>How to install and configure MySQL workbench<\/li><li>How to create a schema and a table via MySQL workbench<\/li><li>How to create an E.R diagram by reverse-engineering an existing schema<\/li><li>How to execute SQL queries<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Software Requirements<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"\"><thead><tr><th>Category<\/th><th>Requirements for Software Version Used<\/th><\/tr><\/thead><tbody><tr><td>System<\/td><td>Ubuntu and many Debian derivatives such as Linux Mint.<\/td><\/tr><tr><td>Software<\/td><td>Mysql-server and Mysql-workbench<\/td><\/tr><tr><td>Other<\/td><td>Privileged access to your Linux system as root or via the\u00a0<code>sudo<\/code>\u00a0command and Active\u00a0<a href=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-on-ubuntu-18-04\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">MySQL server<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Setting up MySQL server<\/strong><\/h4>\n\n\n\n<p>Click <a href=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mysql-on-ubuntu-18-04\/\">here<\/a> to see the instructions for MySQL server installation.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Installation and connection setup<\/strong> <strong>Workbench<\/strong><\/h4>\n\n\n\n<p> To install MySQL workbench on Ubuntu 18.04, all we need to do is to run the following command: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt-get install mysql-workbench <\/pre>\n\n\n\n<p>To launch the program, all we have to do is to go on the Ubuntu app drawer and click on the MySQL workbench launcher icon.<\/p>\n\n\n\n<p>The program will be launched, and the main page will appear <\/p>\n\n\n\n<p>The existing local connection automatically appears in the connection list as\u00a0<code>Local instance<\/code>. We will use it to test the application. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create a new connection<\/strong><\/h4>\n\n\n\n<p>There are many ways we can create a new connection, the most straightforward is by clicking on the &#8220;plus&#8221; button in the main application window. As soon as we do it, a new window will open: we can use it to setup the connection settings. <\/p>\n\n\n\n<p>The first thing to do is to set the <code>Connection Name<\/code>, in this case, we will just use &#8220;test&#8221;. The second thing we must do is to select the\u00a0<code>Connection Method<\/code>. In this case, we will use the default option:\u00a0<code>Standard (TCP\/IP)<\/code>. Further down we must setup the basic connection parameters: the\u00a0<code>hostname<\/code>\u00a0(name or IP address) of the machine on which the MySQL server is running,\u00a0 and the\u00a0<code>port<\/code>\u00a0used for the connection, which by default is\u00a0<code>3306<\/code>. <\/p>\n\n\n\n<p>We must also provide the name of the MySQL&nbsp;<code>user<\/code>&nbsp;we should connect with and its password. We can choose to store the password in the system&nbsp;<code>keychain<\/code>&nbsp;or clear an already stored password by clicking on the &#8220;Clear&#8221; button. If the password is not set here, the application will prompt us to provide it when we use the connection.<\/p>\n\n\n\n<p>Finally, we can set the&nbsp;<code>Default Schema<\/code>&nbsp;to use when we connect to the server. If we leave this field blank, we will be able to select it later from the list of the available ones.<\/p>\n\n\n\n<p>To test the connection we can click on the\u00a0<code>Test Connection<\/code>\u00a0button; to store the connection we just created, instead, we click on the\u00a0<code>OK<\/code>\u00a0one. The connection should now appear in the list on the main program page.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Modify a connection<\/strong><\/h4>\n\n\n\n<p>Modifying a connection is just as easy. We just right-click on an existing connection name and select\u00a0<code>Edit Connection<\/code>\u00a0from the contextual menu that appears. <\/p>\n\n\n\n<p>As soon as we do it, the same window we used to create the connection will open, letting us perform the changes we need. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Delete a connection<\/strong><\/h4>\n\n\n\n<p>To delete an existing connection, we use a similar procedure: we right-click on the section dedicated to the connection in the main application window, but this time we select\u00a0<code>Delete Connection<\/code>\u00a0from the context menu. The application will ask for confirmation before actually deleting the connection.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on Ubuntu 18.04 (Bionic Beaver). In this tutorial you will learn: How to install and configure MySQL workbench How to create a schema and a table [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2943,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[174],"tags":[25,83,267],"class_list":["post-2942","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql","tag-ubuntu","tag-workbench"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Install and Configure MySQL Workbench on Ubuntu Linux | 24x7serversupport Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install and Configure MySQL Workbench on Ubuntu Linux | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on Ubuntu 18.04 (Bionic Beaver). In this tutorial you will learn: How to install and configure MySQL workbench How to create a schema and a table [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-28T04:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-27T22:44:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/\",\"name\":\"Install and Configure MySQL Workbench on Ubuntu Linux | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1\",\"datePublished\":\"2020-03-28T04:45:00+00:00\",\"dateModified\":\"2020-03-27T22:44:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1\",\"width\":200,\"height\":200,\"caption\":\"MySQL Workbench\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install and Configure MySQL Workbench on Ubuntu Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install and Configure MySQL Workbench on Ubuntu Linux | 24x7serversupport Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/","og_locale":"en_US","og_type":"article","og_title":"Install and Configure MySQL Workbench on Ubuntu Linux | 24x7serversupport Blog","og_description":"MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on Ubuntu 18.04 (Bionic Beaver). In this tutorial you will learn: How to install and configure MySQL workbench How to create a schema and a table [&hellip;]","og_url":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/","og_site_name":"24x7serversupport Blog","article_published_time":"2020-03-28T04:45:00+00:00","article_modified_time":"2020-03-27T22:44:23+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1","type":"image\/jpeg"}],"author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/","url":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/","name":"Install and Configure MySQL Workbench on Ubuntu Linux | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#primaryimage"},"image":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1","datePublished":"2020-03-28T04:45:00+00:00","dateModified":"2020-03-27T22:44:23+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#primaryimage","url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1","width":200,"height":200,"caption":"MySQL Workbench"},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/install-and-configure-mysql-workbench-on-ubuntu-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Install and Configure MySQL Workbench on Ubuntu Linux"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/03\/workbench.jpeg?fit=200%2C200&ssl=1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=2942"}],"version-history":[{"count":1,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2942\/revisions"}],"predecessor-version":[{"id":2944,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2942\/revisions\/2944"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media\/2943"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=2942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=2942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=2942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}