944,131 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 3558
  • PHP RSS
Jul 8th, 2005
0

PHP-MySQL Conn Problem in Win XP

Expand Post »
Hi

When I am trying to connect to mySQL from PHP, I am getting the error "Client does not support authentication protocol requested by server; consider upgrading mySQL client" . I am using PHP 4, mySQL 4.1 and Win XP Pro. The error is occuring both for Apache & IIS. I am using the same configurations (including php.ini & httpd.conf) in a Win 98 machine, where it is working perfectly. The php.net site advised recompling with -mysqli option, but since I am in Windows I can't do that.

How can I make this work ?
Thanks
Similar Threads
Reputation Points: 20
Solved Threads: 10
Junior Poster
aparnesh is offline Offline
193 posts
since Jul 2005
Jul 8th, 2005
0

Re: PHP-MySQL Conn Problem in Win XP

Unfortunately, I don't have the experience or time to troubleshoot your exact problem, but I can offer you my WAMP Tutorial which sets up Apache2, PHP5, and MySQL4.1 on Windows XP Home and Pro. It is here:
http://www.daniweb.com/techtalkforums/thread26579.html
Reputation Points: 36
Solved Threads: 6
Posting Whiz
Troy is offline Offline
354 posts
since Jun 2005
Jul 8th, 2005
0

Re: PHP-MySQL Conn Problem in Win XP

This simply happens because of the way php is trying to connect to the mysql server... it has to do with the mysql module in php. Whats weird is that with the exact same configuration, you have it working on win98 (provided the mysql server version is THE SAME that in the xp box).
Likely, there are many solutions... Since im a little tired, Im gonna leave you this:
1. Check the mysql manual (docs folder somewhere in your mysql installation path), as it deals with some possible solutions (that have to do with the way new mysql servers deal with passwords).
2. Google for it, maybe do a search with the error message "Client does not support authentication protocol requested by server; consider upgrading mySQL client", and some good answers might arise. IIRC, one of them is to change the mysql.dll or whatever module for another version or something like that.

Cheers
Reputation Points: 10
Solved Threads: 1
Light Poster
darklordsatan is offline Offline
26 posts
since Jun 2005
Jul 12th, 2005
0

Re: PHP-MySQL Conn Problem in Win XP

Tried your solution, but the old problem persists. Could this be because of php 5 (in ur example) and php4 (that I am installing) ?
Reputation Points: 20
Solved Threads: 10
Junior Poster
aparnesh is offline Offline
193 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Image croping algorithm?
Next Thread in PHP Forum Timeline: Setting up PHP





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC