Home Sqlalchemy and DBvisualizer failing with port fowarding
Reply: 1

Sqlalchemy and DBvisualizer failing with port fowarding

user2820906
1#
user2820906 Published in 2018-02-14 17:41:51Z

To connect to our database, we need to use port forward to connect to the remote instance.

ssh -i [ssh Key] -f -N -L [local port]:[host]:[remote port] [user]@[remote ip]

Afterwards, I can then use this command to access the remote database.

mysql -h 127.0.0.1 -P [local port] -u [database user] -p

If I use the local settings in something like SQLAlchemy or DbVisualizer however, I get

Access denied for user [user]@'10.0.1.70' (using password: YES)

I know the password is correct, so what am I missing in my understanding? What is the difference here between the cli and these other interfaces?

user9101286
2#
user9101286 Reply to 2018-02-15 17:52:23Z

For DbVisualizer, have you tried specifying Database Server as "localhost", as described here:

http://confluence.dbvis.com/display/UG100/Using+an+SSH+Tunnel

Best Regards Hans Bergsten (DbVisualizer developer)

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.29856 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO