Connecting to aws rds instance

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Connecting to aws rds instance

Postby mn2project » 01. February 2017 02:22

I'm not a dba or sysadmin.

The environment.

w7p64, xampp (standard install), xampp control panel says v3.2.2, aws mysql rds 3306 instance with NO security

w7 firewall off, router/gateway security off (All fleeting I assure you), apache down.

1. mysql runs fine with the local database in a windows command shell. From there should I be able to connect
remotely to the rds instance with mysql -h rdsinstance -u rdsusername -p rdspassword ?

where the -h is also know as the 'end point' on the rds control panel.

I haven't been able to make the connection. Could someone give me command example. Maybe I'm using the parameter in the wrong place or forgetting something.

I might mention that php on the ec2 instance can connect using pdo host(endpoint) user (master name) master password, and dbase name. So the information is correct. It has to be how I invoke mysql or a security issue. the command hangs for about 15 seconds.

Another thing is that ssh may(is) involved. I have the key and I can putty into the ec2 instance. I have putty instance open with keys installed and and ssh tunneling setup (what ever that is)
https://www.r-bloggers.com/connecting-toad-for-mysql-mysql-workbench-and-r-to-amazon-aws-ec2-using-ssh-tunneling/

Here they suggest installing an ssh client
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
but I'll hold off on that until someone say the putty setup is not adequate.


Thanks
mn2project
 
Posts: 1
Joined: 01. February 2017 01:32
XAMPP version: 3.2.2
Operating System: w7p64

Re: Connecting to aws rds instance

Postby Altrea » 01. February 2017 05:44

Hi,

You should ask at an AWS support channel. This cannot be an XAMPP issue, so we cannot provide any support for this.

Best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8766
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 1 guest