title: pandas to_sql sqlalchemy connection with secure_transport
body: <p>I am trying to send data to a mysql database on a server that has --require_secure_transport=ON.</p>
  
  <p>When i am trying to connect to it with the following code</p>
  
  <pre><code>import pandas as pd
  import pymysql
  from sqlalchemy import create_engine
  
  connect_string = 'mysql+pymysql://{}:{}@{}/{}'.format(user,pw,host,database)
  connector = create_engine(connect_string)   
  df = pd.read_csv('iris.data')
  df.to_sql('iris',connector,if_exists='replace',index_label='id')
  </code></pre>
  
  <p>i get the following error</p>
  
  <pre><code>InternalError: (pymysql.err.InternalError) (3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.') (Background on this error at: http://sqlalche.me/e/2j85)
  </code></pre>
  
  <p>I have searched for options into how to make the connector use secure_transport, but i haven't been able to find anything that works.</p>
  
  <p>One solution i found called for adding ?ssl=true to the end of the connect_string</p>
  
  <pre><code>connect_string = 'mysql+pymysql://{}:{}@{}/{}?ssl=true'.format(user,pw,host,database)
  </code></pre>
  
  <p>But this gave the following error</p>
  
  <pre><code>    ca = sslp.get('ca')
  
  AttributeError: 'str' object has no attribute 'get'
  </code></pre>
  
  <p>I am able to connect to the database using only pymysql in this way</p>
  
  <pre><code>ssl={'ssl': {'key': 'ssl/client-key.pem','cert': 'ssl/client-cert.pem','ca': 'ssl/ca-cert.pem'}}
  con = pymysql.Connect(host,user,pw,database,ssl=ssl)
  cur = con.cursor()
  cur.execute("show tables;")
  </code></pre>
  
  <p>But i can't find a way to implement this with the sqlalchemy connector.
  Anyone have some suggestions on what to do to get this to work?</p>
  
  <p>Regards</p>