#!/usr/bin/python3

import pymysql.cursors

# Connect to the database
connection = pymysql.connect(
                             user='benutzer',
                             password='geheimes_PassWort',
                             host='192.168.3.146',
                             port=3306,
                             database='mysql',
                             ssl={"fake_flag_to_enable_tls":True},
                             ssl_ca='/var/lib/mysql/ca.pem',
                             connect_timeout=10,
                             autocommit='True',
                             cursorclass=pymysql.cursors.DictCursor
                            )   
print ("connect successful!!")
try:
    print ("================================================================================")
    with connection.cursor() as cursor:
        # SQL-Variablen
        sql = "SHOW VARIABLES LIKE '%ssl%';"
        # Den AbfragenBefehl implementieren (Execute Query).
        cursor.execute(sql)
        print ("cursor.description: ", cursor.description)
        print()
        for row in cursor:
            print(row)
    print ("================================================================================")
    with connection.cursor() as cursor:
        # SQL-Status
        sql = "SHOW STATUS LIKE '%ssl%';"
        # Den AbfragenBefehl implementieren (Execute Query).
        cursor.execute(sql)
        print ("cursor.description: ", cursor.description)
        print()
        for row in cursor:
            print(row)
    print ("================================================================================")
finally:
    # Die Verbindung schließen (Close connection).
    connection.close()