#!/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',
                             connect_timeout=10,
                             autocommit='True',
                             cursorclass=pymysql.cursors.DictCursor
                             )
print ("connect successful!!")
try:
    print ("================================================================================")
    with connection.cursor() as cursor:
        # SQL
        sql = "SELECT Host,User,ssl_type,ssl_cipher,max_connections,max_user_connections,plugin,max_statement_time FROM user;"
        # 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()