Installation error

[Antknee]

Hi. I am using the latest version with the latest version of MySql. I am running WinXP using MiniApache with PHP support.
Appache works fine. I can get to the S9Y index.php page. I fill out all the info, press the Complete_Install button and I get the error:
Could not connect to database; check your settings.
The mySQL error was: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Like I said I have the latest MySql, so I can't upgrade it anymore....
I am using the default username and password for MySql in the S9Y install.
I am confused.
Thanks

[Antknee]

Here is my post install report:

- PRE_INSTALLATION_REPORT -


PHP_INSTALLATION
OPERATING_SYSTEM Windows NT 5.1, i586
WEBSERVER_SAPI apache2handler
PHP version >= 4.1.2 YES, 4.3.10
Database extensions MySQL
Session extension YES
PCRE extension YES
GDlib extension NO
OpenSSL extension NO
mbstring extension NO
iconv extension NO
zlib extension YES
Imagemagick binary NOT_FOUND

PHPINI_CONFIGURATION
RECOMMENDED ACTUAL
safe_mode OFF OFF
register_globals OFF OFF
magic_quotes_gpc OFF OFF
magic_quotes_runtime OFF OFF
session.use_trans_sid OFF OFF
allow_url_fopen ON ON
file_uploads ON ON
post_max_size 10M 4M
upload_max_filesize 10M 2M

PERMISSIONS
C:/www/htdocs/localhost/public_html\/ WRITABLE
C:/www/htdocs/localhost/public_html\/templates_c WRITABLE
C:/www/htdocs/localhost/public_html\/uploads/ WRITABLE

[garvinhicking]

Your problem is not MySQL itself, but the MySQL extension on your webserver.

PHP by default (4.x) installs a 3.23 MySQL Client library. If you use MySQL > 4.1, that client library will fail and you need to recompile the PHP Apache module with MysqlI. Or use PHP5. I don't know much about compiling PHP on Windows, so you'll have to go to the appropriate places instead (PHP/MySQL/Apache mailinglists or so).

You can also use XAMPP, which uses PHP5 and thus mysqli.

Regards,
Garvin