title: How to connect to a MySQL database, via SSH-tunnel, using Python 3.5?
body: <p>I am using windows 7 with Python 3.4 (with Pycharm) and try to acces a remote mySQL-database through SSH with a private key.</p>
  
  <p>I use SSHTunnel (<a href="https://github.com/pahaz/sshtunnel" rel="nofollow">ghithub_link</a>) to setup the SSH-Tunnel as follow :</p>
  
  <pre><code>    from sshtunnel import SSHTunnelForwarder
  
  server = SSHTunnelForwarder(
      ("blablabla.ddns.net", 3307),
      ssh_host_key=None,
      ssh_username="name",
      ssh_password=None,
      ssh_private_key="E:\id_rsa",
      ssh_private_key_password="pssrd",
      remote_bind_address=('192.168.0.24', 3306))
  </code></pre>
  
  <p>The I connect to mySQL database using Oracle's MySQL-connector-Python (<a href="https://dev.mysql.com/doc/connector-python/en/" rel="nofollow">source</a>) as follow :</p>
  
  <pre><code>    cnx=mysql.connector.connect(user='user_worker', password='passwrd',host="blablabla.ddns.net", port=3307, database='base_101')
      cnx.close()
  </code></pre>
  
  <p>I receive the following error : </p>
  
  <pre><code>       Traceback (most recent call last):
  
        File "C:/Users/PycharmProjects/untitled _Get.py", line 37, in &lt;module&gt; cnx=mysql.connector.connect(user='user_worker', password=’pass',host="blablabla.ddns.net", port=22, database=’base_101')
  
        File "C:\Users \Python34\site-packages\mysql\connector\__init__.py", line 179, in connectreturn MySQLConnection(*args, **kwargs)
  
        File "C:\Users \Python34\site-packages\mysql\connector\connection.py", line 95, in __init__self.connect(**kwargs)
  
        File "C:\Users \Python34\site-packages\mysql\connector\abstracts.py", line 719, in connectself._open_connection()
  
        File "C:\Users\YOANN\AppData\Roaming\Python\Python34\site-packages\mysq\connector\connection.py", line 206, in _open_connectionnself._socket.open_connection()
  
        File "C:\Users\YOANN\AppData\Roaming\Python\Python34\site-packages\mysq\connector\network.py", line 475, in open_connection errno=2003, values=(self.get_address(), _strioerror(err)))
  
  
     mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (10061 Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée)
  </code></pre>
  
  <p>I am assuming the problem comes from the ports, but I can't figure it out. In an other hand I can connect to the base via the SSh and SSh-key using the pycharm database tool, so no problem on the server's side nor the key/ssh connection).</p>