468,554 Members | 1,966 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

MySQLdb and MySQL 4.1 server :(

JZ
MySQLdb 1.0 cannot connect to MySQL 4.1 server when the user has non-empty
password :(

_mysql_exceptions.OperationalError: (1251, 'Client does not support
authentication protocol requested by server; consider upgrading MySQL
client')

--
JZ
Jul 18 '05 #1
3 1734
> MySQLdb 1.0 cannot connect to MySQL 4.1 server when the user has non-empty
password :(

_mysql_exceptions.OperationalError: (1251, 'Client does not support
authentication protocol requested by server; consider upgrading MySQL
client')


Is your MySQLdb compiled/linked against MySQL 4.1 libraries?

--
damjan
Jul 18 '05 #2
In article <34****************************@40tude.net>, JZ <z@b.com> wrote:
MySQLdb 1.0 cannot connect to MySQL 4.1 server when the user has non-empty
password :(


This is hardly surpising, as "MySQL-4.1 is not yet supported, and
probably won't be until MySQLdb-1.3 or 2.0." (from the README, which
also says "If you fail to read all of this document and ask questions
that are already answered, I reserve the right to verbally abuse you.")

That said, it *does* work if you build MySQLdb from source (it needs a
minor tweak to _mysql.c if you've got a really recent 4.1, and will
probably need some adjustment to setup.py). MySQL passwords changed
between 4.0 and 4.1.0 and again in 4.1.1 in rather incompatible ways,
so a client binary expecting 4.0 doesn't stand much chance with a 4.1
server.

--
\S -- si***@chiark.greenend.org.uk -- http://www.chaos.org.uk/~sion/
___ | "Frankly I have no feelings towards penguins one way or the other"
\X/ | -- Arthur C. Clarke
her nu becomež se bera eadward ofdun hlęddre heafdes bęce bump bump bump
Jul 18 '05 #3


JZ wrote:
MySQLdb 1.0 cannot connect to MySQL 4.1 server when the user has non-empty
password :(

_mysql_exceptions.OperationalError: (1251, 'Client does not support
authentication protocol requested by server; consider upgrading MySQL
client')

MySQL changed the way they do the PASSWORD() function. try resetting
your mysql users' passwords using OLD_PASSWORD() instead and it will
start working again. I just had this problem two days ago and found the
answer in a simple web search for the error... *(cough)"

Gabriel.
Jul 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Peter Nikolaidis | last post: by
1 post views Thread by Derek Fountain | last post: by
21 posts views Thread by John Fabiani | last post: by
2 posts views Thread by Daniel Baggott | last post: by
4 posts views Thread by fedor | last post: by
1 post views Thread by Steve | last post: by
2 posts views Thread by Mondal | last post: by
2 posts views Thread by Nikhil | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.