DIR : /home/kozerus/public_html/go/dgs/mysql.py

/home/kozerus/public_html/go/dgs

import mysql.connector
from mysql.connector import Error

# pip3 install mysql-connector-python
# pip install mysql-connector-python

def connect():
    """ Connect to MySQL database """
    conn = None
    try:
        conn = mysql.connector.connect(host='localhost',
#                                       database='python_mysql',
#                                       user='root',
#                                       password='SecurePass1!')
                                       database='dgs',
                                       user='root',
                                       password='..root')
        if conn.is_connected():
            print('Connected to MySQL database={}'.format(database))

    except Error as e:
        print(e)

    finally:
        if conn is not None and conn.is_connected():
            conn.close()


if __name__ == '__main__':
    connect()