Comment 48 for bug 2003835

Understanding the root-cause, a workaround would be to ask pymysql for an encrypted connection by adding 'ssl={"verify_mode": ...}'

  import pymysql;

  with pymysql.connect(host='127.0.0.1', port=6446,
      user='<user>', password='<pass>',
      ssl={'verify_mode':0}) as cnx:
    cnx.query('SELECT ...')"

That would bypass all the issues handled above.