View Full Version : MySQL problems
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
08-16-2006, 08:20 PM
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!
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)
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.
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).
Upgrade your PHP version at first. 4.4.1 was very buggy.
01-26-2007, 11:30 AM
Need some help trying to set-up pixelpost on my Pc first.
Windows XP SP2 with IIS 5.1
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
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.
01-26-2007, 01:24 PM
Thanks a LOOTTTTTT !!! :) :)
problem solved !
i use :
EMS SQL Manager for MySQL
and from this link
i found and execute this func
SET PASSWORD FOR 'phd'@'localhost' = OLD_PASSWORD('7755');
thanks for the rapid answer
No problem and have fun posting images :)
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.