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