{"id":1547,"date":"2021-12-09T13:21:04","date_gmt":"2021-12-09T13:21:04","guid":{"rendered":"https:\/\/www.velaninfo.com\/rs\/?post_type=techtips&p=1547"},"modified":"2021-12-27T11:27:39","modified_gmt":"2021-12-27T11:27:39","slug":"how-to-connect-mysql-workbench","status":"publish","type":"techtips","link":"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/","title":{"rendered":"How to Connect MySQL Workbench to MYSQL RDS DB instance using an SSH tunnel?"},"content":{"rendered":"

To connect the EC2 instance and Connect MySQL Workbench RDS DB instance, we must first configure the security group inbound rules, network ACLs, and route tables.<\/p>\n

In addition, we must verify that the EC2 instance<\/strong> <\/a>can connect to the internet from the local PC using its public IP address.<\/p>\n

    \n
  1. First, we have to launch the MySQL Workbench.<\/li>\n
  2. Next, we have to choose MySQL New Connection and give it a name.<\/li>\n
  3. After that, we have to choose Standard TCP\/IP over SSH as the Connection Method.<\/li>\n
  4. Under SSH Hostname, we have to provide the EC2 instance’s public IP address.<\/li>\n
  5. Then, for SSH Username, we have to use the EC2 instance’s default SSH user name.<\/li>\n
  6. Followingly, we have to choose SSH Key File and the .pem<\/strong> file from the file system to connect.<\/li>\n
  7. After that, we have to type the database endpoint name into MySQL Hostname.<\/li>\n
  8. Similarly, we have to enter the port number that we use to connect to the database in the MySQL Server Port<\/strong><\/a> field.<\/li>\n
  9. Then, we have to enter the user name used to connect to the database in Username.<\/li>\n
  10. After that, we have to enter the MySQL user password for Password.<\/li>\n
  11. Finally, we have to choose Test Connection from the drop-down menu. We have to pick OK to save the connection after the test is successful.<\/li>\n<\/ol>\n

    We can use an SSH tunnel to connect to the private RDS DB instance once we’ve configured the connection.<\/p>\n

    At Velan, our server support engineers can help to connect the RDS instances through the SSH tunnel with Connect MySQL Workbench in AWS. If you are interested in our service, please fill the Quick connect form<\/strong><\/a> to get in touch with us.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To connect the EC2 instance and Connect MySQL Workbench RDS DB instance, we must first configure the security group inbound rules, network ACLs, and route tables. In addition, we must verify that the EC2 instance can connect to the internet from the local PC using its public IP address. First, we have to launch the… Continue Reading \"Continue<\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"tags":[],"class_list":["post-1547","techtips","type-techtips","status-publish","hentry","Categories_tech_tip-aws","Categories_tech_tip-ec2"],"yoast_head":"\nConnect MySQL Workbench to MYSQL RDS Database | Velan<\/title>\n<meta name=\"description\" content=\"How do I migrate from Connect MySQL Workbench to RDS? Database instance using an SSH tunnel. For instructions on connecting to your account with SSH\" \/>\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.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect MySQL Workbench to MYSQL RDS DB instance using an SSH tunnel?\" \/>\n<meta property=\"og:description\" content=\"How do I migrate from Connect MySQL Workbench to RDS? Database instance using an SSH tunnel. For instructions on connecting to your account with SSH\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"Velan\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-27T11:27:39+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/\",\"url\":\"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/\",\"name\":\"Connect MySQL Workbench to MYSQL RDS Database | Velan\",\"isPartOf\":{\"@id\":\"https:\/\/www.velaninfo.com\/rs\/#website\"},\"datePublished\":\"2021-12-09T13:21:04+00:00\",\"dateModified\":\"2021-12-27T11:27:39+00:00\",\"description\":\"How do I migrate from Connect MySQL Workbench to RDS? Database instance using an SSH tunnel. For instructions on connecting to your account with SSH\",\"breadcrumb\":{\"@id\":\"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.velaninfo.com\/rs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tech Tips\",\"item\":\"https:\/\/www.velaninfo.com\/rs\/techtips\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Connect MySQL Workbench to MYSQL RDS DB instance using an SSH tunnel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.velaninfo.com\/rs\/#website\",\"url\":\"https:\/\/www.velaninfo.com\/rs\/\",\"name\":\"Velan\",\"description\":\"Velaninfo Services India Pvt Ltd\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.velaninfo.com\/rs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connect MySQL Workbench to MYSQL RDS Database | Velan","description":"How do I migrate from Connect MySQL Workbench to RDS? Database instance using an SSH tunnel. For instructions on connecting to your account with SSH","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.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect MySQL Workbench to MYSQL RDS DB instance using an SSH tunnel?","og_description":"How do I migrate from Connect MySQL Workbench to RDS? Database instance using an SSH tunnel. For instructions on connecting to your account with SSH","og_url":"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/","og_site_name":"Velan","article_modified_time":"2021-12-27T11:27:39+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/","url":"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/","name":"Connect MySQL Workbench to MYSQL RDS Database | Velan","isPartOf":{"@id":"https:\/\/www.velaninfo.com\/rs\/#website"},"datePublished":"2021-12-09T13:21:04+00:00","dateModified":"2021-12-27T11:27:39+00:00","description":"How do I migrate from Connect MySQL Workbench to RDS? Database instance using an SSH tunnel. For instructions on connecting to your account with SSH","breadcrumb":{"@id":"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.velaninfo.com\/rs\/techtips\/how-to-connect-mysql-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.velaninfo.com\/rs\/"},{"@type":"ListItem","position":2,"name":"Tech Tips","item":"https:\/\/www.velaninfo.com\/rs\/techtips\/"},{"@type":"ListItem","position":3,"name":"How to Connect MySQL Workbench to MYSQL RDS DB instance using an SSH tunnel?"}]},{"@type":"WebSite","@id":"https:\/\/www.velaninfo.com\/rs\/#website","url":"https:\/\/www.velaninfo.com\/rs\/","name":"Velan","description":"Velaninfo Services India Pvt Ltd","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.velaninfo.com\/rs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/techtips\/1547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/techtips"}],"about":[{"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/types\/techtips"}],"author":[{"embeddable":true,"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/comments?post=1547"}],"version-history":[{"count":3,"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/techtips\/1547\/revisions"}],"predecessor-version":[{"id":1569,"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/techtips\/1547\/revisions\/1569"}],"wp:attachment":[{"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/media?parent=1547"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.velaninfo.com\/rs\/wp-json\/wp\/v2\/tags?post=1547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}