#!/usr/bin/env python3

#Import required module
import mysql.connector

#Establish connection to database
conn = mysql.connector.connect(host="localhost", user="user", password="password", database="mysql")

#Create cursor
cursor = conn.cursor()

#Create an SQL statement
stmt = "SELECT * FROM user"

#Execute SQL statement
cursor.execute(stmt)

#Get records from executed statement
records = cursor.fetchall()

#Process
print("Total users: ", cursor.rowcount)

for record in records:
    print("User: ", record[1])

#Close connection to database
conn.close()

#Close cursor
cursor.close()