import mysql.connectorcnx = mysql.connector.connect(user=‘scott‘, password=‘tiger‘,host=‘127.0.0.1‘,database=‘employees‘)cnx.close()

import MySQLdbdb = MySQLdb.connect(host="localhost", # your host, usually localhost                     user="john", # your username                      passwd="megajonhy", # your password                      db="jonhydb") # name of the data basecur = db.cursor() cur.execute("SELECT * FROM YOUR_TABLE_NAME")

MySQLdb is a C module that links against the MySQL protocol implementation in the libmysqlclient library. It is faster, but requires the library in order to work.mysql-connector is a Python module that reimplements the MySQL protocol in Python. It is slower, but does not require the C library and so is more portable.