#!/usr/bin/python
# -*- coding: utf-8 -*-
import mysql.connector
def mysqltest():
print("Content-Type: text/html")
print("")
print("")
print("\n\t\n\t\t\n\t\tPython MySQL Driver Test\n\t\n\t")
connect = mysql.connector.connect(
user='root',
password='rootpassword',
host='localhost',
database='mysql',
charset='utf8')
cursor = connect.cursor()
cursor.execute('select User from user')
for row in cursor.fetchall():
print("\t\t" + row[0].decode() + "
")
cursor.close
connect.close
print("\n\t\n")
if __name__ == '__main__':
mysqltest()