python - Connect MySQL on AWS via SSH on Jupyter Notebook -


i'm trying connect mysql on aws via ssh on jupyter notebook. able connect on terminal with:

ssh -l 13306:company.amazonaws.com:3306 user_name -f -n 

and then,

mysql -usupport -h127.0.0.1 --port=13306 -p 

i'm able connect via sequelpro.

however, using mysql python libraries, how can extract data or write query on jupyter notebook?

i use macos sierra.

thanks!


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -