Installing the MySQLdb module for Windows python2.7

Download the corresponding version according to the number of Python bits:

32-bit: https://pypi.python.org/pypi/MySQL-python/1.2.5

64-bit: Http://arquivos.victorjabur.com/python/modules/MySQL-python-1.2.3.win-amd64-py2.7.exe

Download the corresponding version and install it directly.

Enter the code test:

2. Import MySQLdb
6. #-----------MySQL test code-------------
10. Def mysql_test ():
12. Try:
14. Sql=' select * from student '
16. Conn=mysqldb.connect (host=' 127.0.0.1 ', user=' root ', passwd=' test ', db=' test ', port=3306)
18. Cur=conn.cursor ()
20. Cur.execute (SQL)
22. print ' conn:%s '%conn
24. print ' cur:%s '%cur
26. Cur.close ()
28. Conn.close ()
30. except Mysqldb.error,e:
32. print ' MySQL Error%d:%s '% (e.args[0],e.args[1])
36. If __name__=="__main__":
38. Mysql_test ()

The test results show that the connection was successful:

1. Conn:<_mysql.connection open to ' 127.0.0.1 ' at 2d01b28>
2. Cur: <mysqldb.cursors.cursor object at 0x00000000031f9ef0>

If you see the following error, you should change localhost to 127.0.0.1.

1. MySQL error 2013:lost connection to MySQL server @ ' waiting for initial communication packet ', system error: 0

Installing the MySQLdb module for Windows python2.7