python与mysql交互会遇到的各种问题及解决方法

# -*- coding: utf-8 -*-

import MySQLdb

try:

conn=MySQLdb.connect(host='localhost',port='3306',db='test',user='root',passwd='toor',charset='utf-8')

csl=conn.cursor()

count=csl.execute("inser into stu(stu_id,stu_name,stu_phone,stu_hometown) values('0003','kj','19564832601',河北)")

print count

conn.commit()

csl.close()

conn.close()

except Exception,e:

print e.message

an integer is required (got type str)

port=3306

(1129, "Host '192.168.65.1' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")

show variables like 'max_connect_errors';

set global max_connect_errors = 1000;

> show variables like '%max_connect_errors%';

> flush hosts;

# vi /etc/my.cnf

max_connect_errors = 100