Home Sqlalchemy and DBvisualizer failing with port fowarding
Reply: 0

Sqlalchemy and DBvisualizer failing with port fowarding

user729
1#
user729 Published in June 21, 2018, 4:41 am

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?

You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO