Basic connection to MySQL with mysqldb : MySQL « Database « Python Tutorial






import MySQLdb

print "Connecting..."
dbh = MySQLdb.connect(db = "foo")
print "Connection successful."
dbh.close()








15.3.MySQL
15.3.1.Basic connection to MySQL with mysqldb
15.3.2.Connecting to a MySQL Database Server
15.3.3.Creating a MySQL Database
15.3.4.Adding Entries to a MySQL Database
15.3.5.Retrieving Entries from a MySQL Database
15.3.6.Create table, insert data, update data and select data