connection with MySQL with Python interface

pengz1_at_netzero.com
Date: 04/09/04 

Date: Fri, 9 Apr 2004 04:37:57 GMT
To: python-list@python.org

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!

Relevant Pages

  • Re: xlrd: error open_workbook
    ... I am trying to open an .xls file using xlrd, but an error message ... xlrd-Python and to add them in the mySQL database. ... Marc-Andre Lemburg ...
    (comp.lang.python)
  • Re: [PHP] Mysqli issue
    ... Attempting to setup a prepared statement in php that will update a ... record in a mysql database using mysqli ... Here is my error message: ... You have an error in your SQL syntax; ...
    (php.general)
  • Mysqli issue
    ... Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli ... Here is my error message: ... You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(FName, LName, email, phone, record, subscribed, date, IPAddress, Business, Addr' at line 1 ...
    (php.general)
  • Re: [PHP] Mysqli issue
    ... record in a mysql database using mysqli ... Here is my error message: ... You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(FName, LName, email, phone, record, subscribed, date, IPAddress, Business, Addr' at line 1 ...
    (php.general)
  • Re: MySQL vs. DBI/DBD
    ... A simple Google search on the error message: ... > When I run the script I get this error message: ... consider upgrading MySQL client at test.pl line 15 ...
    (perl.dbi.users)