| | |
PHP-MySQL Conn Problem in Win XP
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
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
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
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
http://www.daniweb.com/techtalkforums/thread26579.html
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
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
![]() |
Similar Threads
- I m a beginner in PHP-Mysql (PHP)
- PHP/Mysql Flash problem !!!!1 (PHP)
- php/mysql communication problem (PHP)
- php mysql problem (PHP)
- php mysql help (PHP)
- Using PHP, MySQL and Apache Server (PHP)
Other Threads in the PHP Forum
- Previous Thread: Image croping algorithm?
- Next Thread: Setting up PHP
| Thread Tools | Search this Thread |
advanced alerts apache api archive array autosuggest beginner binary broken cakephp checkbox class clients cms code cron curl database date datepart display dynamic echo email emptydisplayvalue eregi error execute explodefunction file files folder form forms function functions google hack head href htaccess html if...loop image include insert ip javasciptvalidation javascript joomla keywords library limit link login mail matching menu mlm multiple mysql number object oop password paypal pdf php phpincludeissue query radio random recursive remote script search searchbox server sessions shot smarty source space speed sql syntax system table tutorial update upload url validator variable vbulletin video web website youtube





