Python MySQL Database Connection Example

import mysql.connector

conn = mysql.connector.connect(
    host='localhost',
    user='root',
    password='',
    database='test'
)

cursor = conn.cursor()
cursor.execute('SELECT * FROM users')

for row in cursor.fetchall():
    print(row)

conn.close()