Can't connect to the mysql - server
MySQL database connector for Python programming
Brought to you by:
adustman
Menu
▾
▴
Since I' ve changed the character-set of the mysql - server to latin1_de I' m not able to connect to the server (it is running I' m sure). Every time I try this I get the same Win200 error mesage : python.exe crashes with a dump.
This occurs at MySQLdb.connect(...)
Am I doing some thing wrong or is this a bug?
Some versions (python, MySQLdb, MySQL, os) would be of use.
Similarly, sample code you are using to connect would be useful.
Also of interest would by trying to connect to the MySQL server using the standard command line client and also what happens why you try to connect from a different os.
donfede
Sorry, here it comes
Python V 2.0
MySQLdb V 0.9.1
MySQL V 4.0.0-alpha-max-nt
A connect without python is unproblematic.
Differend OS is in progress.
The code is very simple:
import MySQLdb
mysqlCon = MySQLdb.connect(host=myhost,user=myuser,passwd=mypass,db=mydb)
ERROR!
MySQLdb-0.9.1 is officially old; try 0.9.2. Also consider Python 2.2.1.
Used both, see my previous posting, no joy, so most probably won't help the original poster either.
I've got exactly the same problem, on two machines.
Both: ActivePython 2.2.1 build 222, MySQL 3.23.51, using mysqld-nt.exe
Machine A: Windows NT 4.0 SP 6, MySQLdb 9.0.1 and 9.0.2 (same results for both versions)
Machine B: Windows 2000 Pro SP 3, only MySQLdb 9.0.1 so far
Same code as original poster, only parameter "host=myhost" left off, working only locally. Standard command line client works, PHP script works, both sort correctly, which is the goal of the exercise and very important for me (I'm a librarian in a german library).