import mysql.connector

cnx = mysql.connector.connect(user='root', password='canalwebx', host='127.0.0.1', database='test')
cursor = cnx.cursor()

query = ("SELECT * FROM test")

cursor.execute(query)

for result in cursor:
	print(result)

cursor.close()
cnx.close()