import os from sshtunnel import SSHTunnelForwarder from sqlalchemy import create_engine import pandas as pd URL = "{connector}://{user}:{password}@{host}:{port}/{db}?charset=utf8".format( connector='mysql+mysqlconnector', user='VPSのMysqlのユーザー名', password='VPSのMySQLのパスワード', host='localhost', port='3307', db='使いたいDB名') SSH_INFO = { 'ssh_host': 'hoge.sakura.ne.jp', # IP直打ちでもOK 'ssh_port': 22, # 普段SSH