sqlConnection

connectionSql.py

# pip install install mysql-connector-python
import mysql.connector
from mysql.connector import Error

connection = mysql.connector.connect(host='db-mysql-fra1-08423-do-user-8476727-0.b.db.ondigitalocean.com',
                                     database='defaultdb',
                                     port='25060',
                                     user='doadmin',
                                     password='AVNS_gVLHcpWOtMuGqTO')
if connection.is_connected():
    db_Info = connection.get_server_info()
    print("Connected to MySQL Server version ", db_Info)
    cursor = connection.cursor()
    cursor.execute("select database();")
    record = cursor.fetchone()
    print("You're connected to database: ", record)