Home Original page

MySQL + Python + Win32

Jeff Bauer jbauer at rubic.com
Mon Dec 11 10:28:44 EST 2000 
Recently a friend with no Python nor MySQL experience
wanted to try using both on a Win32 platform.  After
telling him it should work fine I decided to check it
out -- since almost all my experience with MySQL has 
been on Linux/Solaris platforms.  The following is a
brief portion of the reply I sent him.

-------------------------------------------------------

This looks pretty straightforward.  I installed Python2.0, 
MySQL 3.23.28-gamma, and the MySQL-python-0.3.0-win32-2.zip
files onto an NT4.0 system.

I used Gerhard's win32 MySQLdb Python interface, compiled
from Andy Dustman's sources:

  http://home.t-online.de/home/err666/

Don't forget to run "python setup.py install" from the
MySQL-python-0.3.0 directory.

First, I test it against a known Unix database server.

D:\jbauer\tmp>python
Python 2.0 (#8, Oct 16 2000, 17:27:58) [MSC 32 bit (Intel)] on win32
Type "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>> connection = MySQLdb.connect(host='domitian', db='fhc', user='jbauer', passwd='XXX')
>>> c = connection.cursor()
>>> c.execute("select ID, LNAME from CLIENT")
450L
>>> for r in c.fetchall():
...     print r[0], r[1]
...
024123 Adelson
019868 Akers
026959 Akers
011502 Ambrose
032352 Anderson
  .
  .
  .

Next, I try connecting to the local NT machine:

>>> ntconn = MySQLdb.connect(host='albatross', db='mysql', user='root')
>>> c = ntconn.cursor()
>>> c.execute("select * from User")
4L
>>> for row in c.fetchall():
...     print row
...
('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y')
('%', '', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', 'N')
('localhost', '', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y')
('%', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y')
>>>

Everything looks peachy. Good Luck!

-Jeff
More information about the Python-list mailing list