hi i have a simple code ;
import MySQLdb
db=MySQLdb.Connection(host='localhost',user='root',db='nuxtv')
root has no password for localhost, i have python2.3 installed on debian sarge system with mysql
i tried that code in 10 debian sarge machines and works well they also have same mysql databases and python.i removed python2.3 (with python2.3-mysqldb) and installed 2.4 with python2.4-mysqldb but nothing same error :/
here is the error
>>> import MySQLdb
>>> db=MySQLdb.Connection(host='localhost',user='root',db='nuxtv')
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.3/site-packages/MySQLdb/init.py", line 66, in Connect
return Connection(args, *kwargs)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 156, in init
self.autocommit(0)
_mysql_exceptions.OperationalError: (1193, "Unknown system variable 'AUTOCOMMIT'")
oh mysql version is 4.0.24_Debian-5-log
thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi i have a simple code ;
import MySQLdb
db=MySQLdb.Connection(host='localhost',user='root',db='nuxtv')
root has no password for localhost, i have python2.3 installed on debian sarge system with mysql
i tried that code in 10 debian sarge machines and works well they also have same mysql databases and python.i removed python2.3 (with python2.3-mysqldb) and installed 2.4 with python2.4-mysqldb but nothing same error :/
here is the error
>>> import MySQLdb
>>> db=MySQLdb.Connection(host='localhost',user='root',db='nuxtv')
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.3/site-packages/MySQLdb/init.py", line 66, in Connect
return Connection(args, *kwargs)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 156, in init
self.autocommit(0)
_mysql_exceptions.OperationalError: (1193, "Unknown system variable 'AUTOCOMMIT'")
oh mysql version is 4.0.24_Debian-5-log
thanks.