connection with MySQL with Python interface

[pengz1]

Hi! All
When I tried to connect with MySQL database which run on XP from shell. I got following error message. Has anyone get similar error message and provide any suggestion? Thanks in advance.

Zhiyong


Traceback (most recent call last):
File "C:\Python22\databaseAccess.py", line 4, in ?
con=MySQLdb.connect(host="127.0.0.1",port=3306,user="pengz",passwd="zhiy4318",db="e_retail_store")
File "C:\PYTHON22\Lib\site-packages\MySQLdb\__init__.py", line 63, in Connect
return apply(Connection, args, kwargs)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 115, in __init__
self._make_connection(args, kwargs2)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' (10061)")
Traceback (most recent call last):
File "C:\Python22\databaseAccess.py", line 4, in ?
con=MySQLdb.connect(host="127.0.0.1",port=3306,user="pengz",passwd="zhiy4318",db="e_retail_store")
File "C:\PYTHON22\Lib\site-packages\MySQLdb\__init__.py", line 63, in Connect
return apply(Connection, args, kwargs)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 115, in __init__
self._make_connection(args, kwargs2)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (1250, 'Client does not support authentication protocol requested by server; consider upgrading MySQL client')

________________________________________________________________
The best thing to hit the Internet in years - NetZero HiSpeed!
Surf the Web up to FIVE TIMES FASTER!
Only $14.95/ month -visit www.netzero.com to sign up today!

 

[Marco Bartel]

Hi! All
When I tried to connect with MySQL database which run on XP from shell. I got following error message. Has anyone get similar error message and provide any suggestion? Thanks in advance.

Zhiyong


Traceback (most recent call last):
File "C:\Python22\databaseAccess.py", line 4, in ?
con=MySQLdb.connect(host="127.0.0.1",port=3306,user="pengz",passwd="zhiy4318",db="e_retail_store")
File "C:\PYTHON22\Lib\site-packages\MySQLdb\__init__.py", line 63, in Connect
return apply(Connection, args, kwargs)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 115, in __init__
self._make_connection(args, kwargs2)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' (10061)")
Traceback (most recent call last):
File "C:\Python22\databaseAccess.py", line 4, in ?
con=MySQLdb.connect(host="127.0.0.1",port=3306,user="pengz",passwd="zhiy4318",db="e_retail_store")
File "C:\PYTHON22\Lib\site-packages\MySQLdb\__init__.py", line 63, in Connect
return apply(Connection, args, kwargs)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 115, in __init__
self._make_connection(args, kwargs2)
File "C:\PYTHON22\Lib\site-packages\MySQLdb\connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (1250, 'Client does not support authentication protocol requested by server; consider upgrading MySQL client')

________________________________________________________________
The best thing to hit the Internet in years - NetZero HiSpeed!
Surf the Web up to FIVE TIMES FASTER!
Only $14.95/ month -visit www.netzero.com to sign up today!

Hi Zhiyong,
I think this error is raised by an incompatible clientlibrary shipped
with mysql. You have to know that a client needs to have a mysql-client
library and a mysql-shared library, for accessing a mysql-database.
Under windows I only used mysql with win2000 not with XP, but when i
remember right, the client, and the shared-library are not part of the
main mysql-package, and have to be downloaded and installed seperatly.

Maybe I helped you a little bit, becaus e the code of your program looks
fine.

CU
Marco