title: Python - MySQL SSL Connections
body: <p>I have a MySQL Server set up to use SSL and I also have the CA Certificate.</p>
  
  <p>When I connect to the server using MySQL Workbench, I do not need the certificate. I can also connect to the server using Python and MySQLdb on a Mac without the CA-certificate.</p>
  
  <p>But when I try to connect using the exact same setup of Python and MySQLdb on a windows machine, I get access denied. It appears that I need the CA. And when I enter the CA, I get the following error</p>
  
  <p><code>_mysql_exceptions.OperationalError: (2026, 'SSL connection error')</code></p>
  
  <p>My code to open the connection is below:</p>
  
  <pre><code>db = MySQLdb.connect(host="host.name",    
                   port=3306,
                   user="user",         
                   passwd="secret_password",  
                   db="database", 
                   ssl={'ca': '/path/to/ca/cert'})  
  </code></pre>
  
  <p>Could anyone point out what the problem is on a windows?</p>