March 20th, 2005, 04:40 PM
Traceback (most recent call last):
File "C:\Documents and Settings\Arpan Shah\Desktop\Ex.py", line 5, in -toplevel-
db = MySQLdb.connect(host="localhost", user="root",passwd="abcdef",db="test")
File "C:\Python23\Lib\site-packages\MySQLdb\__init__.py", line 63, in Connect
return apply(Connection, args, kwargs)
File "C:\Python23\Lib\site-packages\MySQLdb\connections.py", line 115, in __init__
File "C:\Python23\Lib\site-packages\MySQLdb\connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (1251, 'Client does not support authentication protocol requested by server; consider upgrading MySQL client')
March 20th, 2005, 04:47 PM
Sha' please do not ask the same question in multiple threads. Also, try to limit the amount of threads you create by keeping related problems together.
This makes it much easier for people to follow as well as improving your chance of getting quick reply .
March 20th, 2005, 04:50 PM
This thread talks about that problem.
SET PASSWORD FOR 'some_user'@locahost = OLD_PASSWORD('newpwd');
(where 'some_user' is your user name and 'newpwd' is your password.)