Python连接MySQL

win10、Python2.7、Pycharm

 

import MySQLdb

conn = MySQLdb.Connect(
   host = '127.0.0.1',
    port = 3306,
    user = 'root',
    passwd = '12369',
    db = 'test',
    charset = 'utf8'

)

cursor  = conn.cursor()

print conn
print cursor

cursor.close()
conn.close()