mySQL Workbench on Windows through two SSH hostsUse Windows/Mac MySQL GUI over SSH TunnelPopulate a remote...

What is this waxed root vegetable?

Test pad's ESD protection

Linear regression when Y is bounded and discrete

Non-Italian European mafias in USA?

What happened to QGIS 2.x

I encountered my boss during an on-site interview at another company. Should I bring it up when seeing him next time?

How to speed up a process

Where is the fallacy here?

Is the set of paths between any two points moving only in units on the plane countable or uncountable?

What is a term for a function that when called repeatedly, has the same effect as calling once?

How can I handle a player who pre-plans arguments about my rulings on RAW?

A right or the right?

What does 'open position for bachelor project' actually mean?

What should one use the left pedal for on an upright?

Citing contemporaneous (interlaced?) preprints

Center single line(s) in align

How to approximate rolls for potions of healing using only d6's?

Where was Karl Mordo in Infinity War?

Tcolorbox as an item in list environment

When should a commit not be version tagged?

chrony vs. systemd-timesyncd – What are the differences and use cases as NTP clients?

How to reorder street address on checkout page in magento 2?

If nine coins are tossed, what is the probability that the number of heads is even?

What is the wife of a henpecked husband called?



mySQL Workbench on Windows through two SSH hosts


Use Windows/Mac MySQL GUI over SSH TunnelPopulate a remote databse using MySQL Workbench and remote .sql fileTunnel to MySql via workbench not working when regular ssh tunnel worksConnect to Database on Same Network But Different Machine From Mysql WorkbenchMySQL seems to ignore --host argumentTotal newb having SSH tunnel and remote MySQL access problemsTunnel windows VPN through SSHAccessing Mysql Database through ssh tunnel in SQL ServerMYSQ Workbench migrating a databaseTrying to connect to database via Putty with jump box













0















I'm attempting to connect to mySQL through two SSH hosts and haven't been able to find a solution anywhere online.



If I were connecting with Putty, I would connect to the first box (let's call it MainBox), and then "ssh subBox". Then at that point I'd be able to log into mySQL. However, on workbench I can't jump through multiple hosts like this, and I have no other way to access the database.



How can I do this?










share|improve this question



























    0















    I'm attempting to connect to mySQL through two SSH hosts and haven't been able to find a solution anywhere online.



    If I were connecting with Putty, I would connect to the first box (let's call it MainBox), and then "ssh subBox". Then at that point I'd be able to log into mySQL. However, on workbench I can't jump through multiple hosts like this, and I have no other way to access the database.



    How can I do this?










    share|improve this question

























      0












      0








      0








      I'm attempting to connect to mySQL through two SSH hosts and haven't been able to find a solution anywhere online.



      If I were connecting with Putty, I would connect to the first box (let's call it MainBox), and then "ssh subBox". Then at that point I'd be able to log into mySQL. However, on workbench I can't jump through multiple hosts like this, and I have no other way to access the database.



      How can I do this?










      share|improve this question














      I'm attempting to connect to mySQL through two SSH hosts and haven't been able to find a solution anywhere online.



      If I were connecting with Putty, I would connect to the first box (let's call it MainBox), and then "ssh subBox". Then at that point I'd be able to log into mySQL. However, on workbench I can't jump through multiple hosts like this, and I have no other way to access the database.



      How can I do this?







      mysql ssh linux-networking port-forwarding putty






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 11 '17 at 21:57









      KoronakeshKoronakesh

      12




      12






















          2 Answers
          2






          active

          oldest

          votes


















          0














          The main issue here is that you need to set a shh tunnel in the first step and then use it as a bridge to get the workbench communication to mySQL database in the 3306 (or whatever configured port).



          What putty really does is to set a ssh connection, which let hosts to exchange keys and establish the ssh protocol communication in port 22. The workbench wont do that but you can set the environment independently.



          Please refer to these 2 references and provide feeback.
          Access Your Database Remotely Through An SSH Tunnel
          Standard TCP/IP over SSH Connection Method






          share|improve this answer































            0














            add this to your ssh config:



            Match host=*.swim.swf
            proxycommand ssh -q -W %h:%p swim-bastion






            share|improve this answer








            New contributor




            Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
            Check out our Code of Conduct.




















              Your Answer








              StackExchange.ready(function() {
              var channelOptions = {
              tags: "".split(" "),
              id: "2"
              };
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function() {
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled) {
              StackExchange.using("snippets", function() {
              createEditor();
              });
              }
              else {
              createEditor();
              }
              });

              function createEditor() {
              StackExchange.prepareEditor({
              heartbeatType: 'answer',
              autoActivateHeartbeat: false,
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f837727%2fmysql-workbench-on-windows-through-two-ssh-hosts%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              0














              The main issue here is that you need to set a shh tunnel in the first step and then use it as a bridge to get the workbench communication to mySQL database in the 3306 (or whatever configured port).



              What putty really does is to set a ssh connection, which let hosts to exchange keys and establish the ssh protocol communication in port 22. The workbench wont do that but you can set the environment independently.



              Please refer to these 2 references and provide feeback.
              Access Your Database Remotely Through An SSH Tunnel
              Standard TCP/IP over SSH Connection Method






              share|improve this answer




























                0














                The main issue here is that you need to set a shh tunnel in the first step and then use it as a bridge to get the workbench communication to mySQL database in the 3306 (or whatever configured port).



                What putty really does is to set a ssh connection, which let hosts to exchange keys and establish the ssh protocol communication in port 22. The workbench wont do that but you can set the environment independently.



                Please refer to these 2 references and provide feeback.
                Access Your Database Remotely Through An SSH Tunnel
                Standard TCP/IP over SSH Connection Method






                share|improve this answer


























                  0












                  0








                  0







                  The main issue here is that you need to set a shh tunnel in the first step and then use it as a bridge to get the workbench communication to mySQL database in the 3306 (or whatever configured port).



                  What putty really does is to set a ssh connection, which let hosts to exchange keys and establish the ssh protocol communication in port 22. The workbench wont do that but you can set the environment independently.



                  Please refer to these 2 references and provide feeback.
                  Access Your Database Remotely Through An SSH Tunnel
                  Standard TCP/IP over SSH Connection Method






                  share|improve this answer













                  The main issue here is that you need to set a shh tunnel in the first step and then use it as a bridge to get the workbench communication to mySQL database in the 3306 (or whatever configured port).



                  What putty really does is to set a ssh connection, which let hosts to exchange keys and establish the ssh protocol communication in port 22. The workbench wont do that but you can set the environment independently.



                  Please refer to these 2 references and provide feeback.
                  Access Your Database Remotely Through An SSH Tunnel
                  Standard TCP/IP over SSH Connection Method







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Mar 11 '17 at 22:33









                  negrotico19negrotico19

                  111




                  111

























                      0














                      add this to your ssh config:



                      Match host=*.swim.swf
                      proxycommand ssh -q -W %h:%p swim-bastion






                      share|improve this answer








                      New contributor




                      Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                      Check out our Code of Conduct.

























                        0














                        add this to your ssh config:



                        Match host=*.swim.swf
                        proxycommand ssh -q -W %h:%p swim-bastion






                        share|improve this answer








                        New contributor




                        Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                        Check out our Code of Conduct.























                          0












                          0








                          0







                          add this to your ssh config:



                          Match host=*.swim.swf
                          proxycommand ssh -q -W %h:%p swim-bastion






                          share|improve this answer








                          New contributor




                          Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.










                          add this to your ssh config:



                          Match host=*.swim.swf
                          proxycommand ssh -q -W %h:%p swim-bastion







                          share|improve this answer








                          New contributor




                          Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.









                          share|improve this answer



                          share|improve this answer






                          New contributor




                          Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.









                          answered 11 mins ago









                          Pieter WillaertPieter Willaert

                          1011




                          1011




                          New contributor




                          Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.





                          New contributor





                          Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.






                          Pieter Willaert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Server Fault!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f837727%2fmysql-workbench-on-windows-through-two-ssh-hosts%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Фонтен-ла-Гаярд Зміст Демографія | Економіка | Посилання |...

                              Список ссавців Італії Природоохоронні статуси | Список |...

                              Маріан Котлеба Зміст Життєпис | Політичні погляди |...