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