i trying connect mysql server on aws instance, using toad w. ssh.
for reference, have following configuration setup in navicat mysql:
general tab:
----------
- connection name: localhost_3306
- host name/ip address: localhost
- port : 3306
- username : xxx
- password : xxx1
- save password: yes
ssh tab:
-----------
- use ssh tunnel : yes
- host name/ip address: xxx.xxx.xxx.xxx (my aws instance ip)
- port: 22
- user name: xxx3
- authentication method: public key
- private key: c:\path_to_my.pem
this works great in navicat, can connect server , open db, no access issues. question is, how setup similar connection in toad mysql? need use external tunnel (e.g. putty) , somehow configure toad connect through there, or can connect directly toad?
a complete working example of similar setup great.
yes can within toad, add new connection in "connection manager". there have "connection type" dropdown-menu. chose "ssh" , fill in required parameters database , ssh-host. can distinct parameters prefix "ssh".
Comments
Post a Comment