import mysql.connector
from mysql.connector import Error

connection = mysql.connector.connect(host='127.0.0.1',
                             database='sbdb_pce67_pcb_novellus_c2_i',
                             user='root',
                             password='sdbd')

try:
    if connection.is_connected():
       db_Info = connection.get_server_info()
       print("Connected to MySQL database... MySQL Server version on ",db_Info)
       cursor = connection.cursor()
       cursor.execute("select database();")
       record = cursor.fetchone()
       print ("Your connected to - ", record)
except Error as e :
    print ("Error while connecting to MySQL", e)
finally:
    #closing database connection.
    if(connection.is_connected()):
        cursor.close()
        connection.close()
        print("MySQL connection is closed")

runfile('C:/Users/kashy/OneDrive/Desktop/Thesis_KM.py', wdir='C:/Users/kashy/OneDrive/Desktop')
Traceback (most recent call last):

  File "<ipython-input-10-56bf75f0124d>", line 1, in <module>
    runfile('C:/Users/kashy/OneDrive/Desktop/Thesis_KM.py', wdir='C:/Users/kashy/OneDrive/Desktop')

  File "C:UserskashyAnaconda3envspy36libsite-packagesspyder_kernelscustomizespydercustomize.py", line 704, in runfile
    execfile(filename, namespace)

  File "C:UserskashyAnaconda3envspy36libsite-packagesspyder_kernelscustomizespydercustomize.py", line 108, in execfile
    exec(compile(f.read(), filename, 'exec'), namespace)

  File "C:/Users/kashy/OneDrive/Desktop/Thesis_KM.py", line 22, in <module>
    password='sbdb')

  File "C:UserskashyAnaconda3envspy36libsite-packagesmysqlconnector__init__.py", line 172, in connect
    return CMySQLConnection(*args, **kwargs)

  File "C:UserskashyAnaconda3envspy36libsite-packagesmysqlconnectorconnection_cext.py", line 78, in __init__
    self.connect(**kwargs)

  File "C:UserskashyAnaconda3envspy36libsite-packagesmysqlconnectorabstracts.py", line 731, in connect
    self._open_connection()

  File "C:UserskashyAnaconda3envspy36libsite-packagesmysqlconnectorconnection_cext.py", line 179, in _open_connection
    sqlstate=exc.sqlstate)

InterfaceError: SSL connection error: Failed to set ciphers to use

show variables like '%ssl%';

+---------------------+-------------+
| Variable_name       | Value       |
+---------------------+-------------+
| have_openssl        | NO          |
| have_ssl            | DISABLED    |
| ssl_ca              |             |
| ssl_capath          |             |
| ssl_cert            |             |
| ssl_cipher          |             |
| ssl_crl             |             |
| ssl_crlpath         |             |
| ssl_key             |             |
| version_ssl_library | YaSSL 2.4.4 |
+---------------------+-------------+