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
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
add a comment |
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
add a comment |
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
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
mysql ssh linux-networking port-forwarding putty
asked Mar 11 '17 at 21:57
KoronakeshKoronakesh
12
12
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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
add a comment |
add this to your ssh config:
Match host=*.swim.swf
proxycommand ssh -q -W %h:%p swim-bastion
New contributor
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
add a comment |
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
add a comment |
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
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
answered Mar 11 '17 at 22:33
negrotico19negrotico19
111
111
add a comment |
add a comment |
add this to your ssh config:
Match host=*.swim.swf
proxycommand ssh -q -W %h:%p swim-bastion
New contributor
add a comment |
add this to your ssh config:
Match host=*.swim.swf
proxycommand ssh -q -W %h:%p swim-bastion
New contributor
add a comment |
add this to your ssh config:
Match host=*.swim.swf
proxycommand ssh -q -W %h:%p swim-bastion
New contributor
add this to your ssh config:
Match host=*.swim.swf
proxycommand ssh -q -W %h:%p swim-bastion
New contributor
New contributor
answered 11 mins ago
Pieter WillaertPieter Willaert
1011
1011
New contributor
New contributor
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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