title: mysql connector python fails with "3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON."
body: <p>I'm trying to connect to mysql DB using mysql-connector-python 8.0.28 and receiving SSL error. Python version is 3.7.5. MySQL version is 8.025.</p>
  <p>We can't disabled <code>--require_secure_transport=ON</code> as customer wants security. We tried <code>ssl_disabled = True</code> option from mysql connector <a href="https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html" rel="nofollow noreferrer">documentation</a>.</p>
  <pre class="lang-py prettyprint-override"><code>try:
              self.conn = mysql.connector.connect(host=host,user=user,password=key, database='xxxx', port=3306, ssl_disabled=True)
              self.info = self.conn.get_server_info()
              #print(self.info)
              self.cursor = self.conn.cursor(dictionary=True)
              return self
          except Error as e:
              logger.error(str(e))
  </code></pre>
  <p>Does anyone has workaround for this issue?</p>