Hi!
I have some problems with installation WikiMedia on my site with next software installed on system: FreeBSD 4.1 Apache 2.0.51 mysql-max-4.1.5-gamma-unknown-freebsd4.7-i386 php-4.3.9 Problem discribed here http://mail.wikipedia.org/pipermail/mediawiki-l/2004-August/001021.html ( this is error in the beginning of installation )
Reason can be finded here: http://dev.mysql.com/doc/mysql/en/Old_client.html ( MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1 )
One of possible solutions:
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function: mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
It's must make it twice: 1. For database user root ( I dont remember error message) 2. For database user wikiuser ( Error message "Sorry! The wiki is experiencing some technical difficulties, and cannot contact the database server")
PS Sorry for small english :\
wikitech-l@lists.wikimedia.org