import mariadb

conn = mariadb.connect(
    host="localhost",
    user="python_test",
    password="uffe",
    database="python_test"
)

cursor = conn.cursor()

cursor.execute("SELECT id, namn FROM personer")

for id, namn in cursor:
    print(f"{id}: {namn}")

conn.close()