connection with MySQL with Python interface

[pengz1 at netzero.com]

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!