title: Can I connect to GHTorrent MySQL/Mongodb database through ssh?
body: <p>I am trying to connect to GHTorrent database through ssh in python so I can deal with the data.</p>
  
  <p>There is the example of how this ssh works in command lines and it works.
  <a href="http://ghtorrent.org/mysql.html" rel="nofollow noreferrer">http://ghtorrent.org/mysql.html</a></p>
  
  <pre><code>import pymysql
  from sshtunnel import SSHTunnelForwarder
  
  mypkey = paramiko.RSAKey.from_private_key_file("/Users/***/.ssh/id_rsa")
  with SSHTunnelForwarder(
       ('web.ghtorrent.org', 3306), 
          ssh_username="ghtorrent",  
          ssh_pkey=mypkey, 
          ssh_private_key_password="*****",#my password for my pc
          remote_bind_address=('web.ghtorrent.org', 3306)) as server:  
      conn = pymysql.connect(host='127.0.0.1', 
                         port=server.local_bind_port,
                         user='ght', 
                         passwd='', 
                         db='ghtorrent')
  </code></pre>
  
  <p>From my code the ssh can't connect to the server. I am not really sure whether my connection information is correct. </p>
  
  <p>Since it uses a website name rather than the IP address so I have no idea whether it works.</p>
  
  <p>Thank you so much!</p>