MySQL problems

[mawz]

I'm getting:


Error Message:
Connect DB Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client Cause #2

Running pixelpost 1.5 and MySQL 4.1.12-standard

Any ideas?

[Connie]

we need info about server version, PHP version and MySQL version

this forum has a search function

we have a wiki (wiki.pixelpost.org)

so I think you might find info and howtos here, good luck!

[mawz]

PHP version is 4.4.1, the rest of the info you request was already in the initial post.

I've checked the wiki already, it has very little usable MySQL troubleshooting info in it, and a forum search turned up nothing.

It's not a PHP->MySQL versioning issue, as punBB is having no issues talking to the MySQL server (the same server is running 2 punBB forums, MySQL is running on localhost)

[GeoS]

As you have this error it looks like you have some MySQL client (used by PHP) <-> MySQL server problem. Talk with your ISP about this issue.

[mawz]

GeoS: No isp involved, I run the webserver myself. PHP and MySQL can talk to each other just fine (two punBB forums are also running on the server, using PHP and MySQL).

[GeoS]

Upgrade your PHP version at first. 4.4.1 was very buggy.

[PhilipD]

Need some help trying to set-up pixelpost on my Pc first.

PHP 4.4.4
MySQL 5.0
Windows XP SP2 with IIS 5.1
Pixelpost 1.5

Trying to run install.php and take this message

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\admin\install.php on line 40
Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[GeoS]

MySQL client at your server uses old method of transfering password datas. You must update your password in MySQL database in users table using old_password() function.

[PhilipD]

Thanks a LOOTTTTTT !!! :) :)

problem solved !

i use :
EMS SQL Manager for MySQL

and from this link
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

i found and execute this func

SET PASSWORD FOR 'phd'@'localhost' = OLD_PASSWORD('7755');

thanks for the rapid answer

[GeoS]

No problem and have fun posting images :)