Python - Connect mysql

test-mysql.py

import mysql.connector

# The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection object.
cnx = mysql.connector.connect(
    host="localhost",
    database="schema",
    user="root",
    password="password"
)

# Test the connection
print(cnx)

cursor = cnx.cursor()

cursor.execute("select * from TABLE_NAME")

for x in cursor:
    print(x)

cnx.close()