title: Using SSL with SQLAlchemy
body: <p>I've recently changed my project to use SQLAlchemy and my project runs fine, it used an external MySQL server.</p>
  
  <p>Now I'm trying to work with a different MySQL server with SSL CA, and it doesn't connect.</p>
  
  <p>(It did connect using MySQL Workbench, so the certificate should be fine)</p>
  
  <p>I'm using the following code:</p>
  
  <pre><code>ssl_args = {'ssl': {'ca': ca_path}}
  engine = create_engine("mysql+pymysql://&lt;user&gt;:&lt;pass&gt;@&lt;addr&gt;/&lt;schema&gt;",
                          connect_args=ssl_args)
  </code></pre>
  
  <p>and I get the following error:</p>
  
  <blockquote>
    <p>Can't connect to MySQL server on '\addr\' ([WinError 10054] An existing connection was forcibly closed by the remote host)</p>
  </blockquote>
  
  <p>Any suggestions?</p>