title: ssh first with mysqldb in python
body: <p>I'm trying to connect to a MySQL database on a remote server using MySQLdb in python.  The problem is that first I need to SSH into the host, and then from there, I need to connect to the MySQL server.  The problem I'm having, though, is that MySQLdb does not seem to have a way of establishing an SSH connection before connecting to the SQL server.  I've checked the documentation but have not had any luck.</p>
  
  <p>This is how I'm connecting:</p>
  
  <pre><code>conn = MySQLdb.connect(host = 'mysqlhost.domain.com:3306', user = 'user', passwd = 'password', db = 'dbname')
  </code></pre>
  
  <p>But what I really need is something like this:</p>
  
  <pre><code>conn = MySQLdb.connect(sshhost = 'sshhost.domain.com', sshuser = 'sshusername', sshpasswd = 'sshpasswd', host = 'mysqlhost.domain.com:3306', user = 'user', passwd = 'password', db = 'dbname')
  </code></pre>
  
  <p>Which is of course just made up.  Can anyone make any recommendations?</p>