[Mediawiki-l] MySQL 4.1 authentication problems

[Brion Vibber]

MySQL 4.1.7 has just been declared a production-ready 'general 
availability' release. Before you all rush out and upgrade, note that a 
number of people have reported some problems with MediaWiki failing 
during installation on MySQL 4.1, due to a change in the authentication 
protocol.

I've done a little testing, and it looks like the proper fix for this 
is to recompile PHP after you've upgraded MySQL, so it uses the updated 
MySQL client libraries.

The other workaround is to fiddle with the user account to set it to a 
backwards-compatible mode (if you upgrade an existing database from 4.0 
to 4.1, existing accounts should already be in this mode), as described 
here:
http://dev.mysql.com/doc/mysql/en/Old_client.html

-- brion vibber (brion @ pobox.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20041026/2851c15a/attachment.pgp