Sfrgttk

Why hard-Brexiteers don't insist on a hard border to prevent illegal immigration after Brexit?

How to deal with fear of taking dependencies

How to answer pointed "are you quitting" questioning when I don't want them to suspect

What does ひと匙 mean in this manga and has it been used colloquially?

How to notate time signature switching consistently every measure

Should I use my personal e-mail address, or my workplace one, when registering to external websites for work purposes?

What did it mean to "align" a radio?

Would the motor reverse if phases swapped for this case?

What tool would a Roman-age civilization have for the breaking of silver and other metals into dust?

Is bread bad for ducks?

What is the meaning of the verb "bear" in this context?

Write faster on AT24C32

Why do UK politicians seemingly ignore opinion polls on Brexit?

One word riddle: Vowel in the middle

What does "fetching by region is not available for SAM files" means?

Worn-tile Scrabble

Is three citations per paragraph excessive for undergraduate research paper?

Output the Arecibo Message

Return to UK after being refused entry years previously

Does a dangling wire really electrocute me if I'm standing in water?

Loose spokes after only a few rides

Why is the maximum length of OpenWrt’s root password 8 characters?

Identify This Plant (Flower)

Scaling a graph of a circle and the standard parabola in TikZ

Cannot connect to Aurora RDS using workbench over ssh

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

1

I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/architecture.html

The private subnet includes:

• an EC2 instance (web server)


• an Aurora RDS that connects to the web server

The public subnet includes:

• a bastion instance for ssh connections to the EC2 instance in the private subnet

Generally, i can connect to Aurora RDS via ssh by connecting to the bastion host, then connecting to the private EC2 instance and then to the RDS but this makes it really hard to perform simple tasks on the RDS

Is it possible to connect to the RDS using mySQL workbench over ssh through the bastion?

I've tried everything but nothing seems to work

Thanks

mysql-workbench aws aurora

share|improve this question

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

bumped to the homepage by Community♦ 1 min ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

1

I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/architecture.html

The private subnet includes:

• an EC2 instance (web server)


• an Aurora RDS that connects to the web server

The public subnet includes:

• a bastion instance for ssh connections to the EC2 instance in the private subnet

Generally, i can connect to Aurora RDS via ssh by connecting to the bastion host, then connecting to the private EC2 instance and then to the RDS but this makes it really hard to perform simple tasks on the RDS

Is it possible to connect to the RDS using mySQL workbench over ssh through the bastion?

I've tried everything but nothing seems to work

Thanks

mysql-workbench aws aurora

share|improve this question

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

bumped to the homepage by Community♦ 1 min ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/architecture.html

The private subnet includes:

• an EC2 instance (web server)


• an Aurora RDS that connects to the web server

The public subnet includes:

• a bastion instance for ssh connections to the EC2 instance in the private subnet

Generally, i can connect to Aurora RDS via ssh by connecting to the bastion host, then connecting to the private EC2 instance and then to the RDS but this makes it really hard to perform simple tasks on the RDS

Is it possible to connect to the RDS using mySQL workbench over ssh through the bastion?

I've tried everything but nothing seems to work

Thanks

mysql-workbench aws aurora

share|improve this question

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

share|improve this question

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

share|improve this question

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

asked Dec 5 '17 at 15:33

DimitrisDimitris

1

1 Answer
1

active

oldest

votes

0

This took me forever....

Other than the permissions in the security groups that i set initially, i had to allow port forward on the bastion instance.

1. connect to the bastion instance via SSH


2. go to /etc/ssh


3. sudo nano sshd_config


4. Set: AllowPortForwarding yes


5. restart the instance


6. Connect with workbench

share|improve this answer

answered Dec 5 '17 at 20:22

DimitrisDimitris

1

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f192436%2fcannot-connect-to-aurora-rds-using-workbench-over-ssh%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

This took me forever....

Other than the permissions in the security groups that i set initially, i had to allow port forward on the bastion instance.

1. connect to the bastion instance via SSH


2. go to /etc/ssh


3. sudo nano sshd_config


4. Set: AllowPortForwarding yes


5. restart the instance


6. Connect with workbench

share|improve this answer

answered Dec 5 '17 at 20:22

DimitrisDimitris

1

add a comment | 

0

This took me forever....

Other than the permissions in the security groups that i set initially, i had to allow port forward on the bastion instance.

1. connect to the bastion instance via SSH


2. go to /etc/ssh


3. sudo nano sshd_config


4. Set: AllowPortForwarding yes


5. restart the instance


6. Connect with workbench

share|improve this answer

answered Dec 5 '17 at 20:22

DimitrisDimitris

1

add a comment | 

This took me forever....

Other than the permissions in the security groups that i set initially, i had to allow port forward on the bastion instance.

1. connect to the bastion instance via SSH


2. go to /etc/ssh


3. sudo nano sshd_config


4. Set: AllowPortForwarding yes


5. restart the instance


6. Connect with workbench

share|improve this answer

answered Dec 5 '17 at 20:22

DimitrisDimitris

1

share|improve this answer

answered Dec 5 '17 at 20:22

DimitrisDimitris

1

answered Dec 5 '17 at 20:22

DimitrisDimitris

1

answered Dec 5 '17 at 20:22

DimitrisDimitris

1