| Author |
Client does not support authentication
|
|
|
| I had an unfortunate incident installing SP2.
I had to reload my distribution disk of XP Professional and then re-apply SP2.
I then activated IIS
Then installed php (php-5.0.2-installer)
I then installed MySQL (mysql-4.1.7-essential-win)
I then uncommented the MySQL extention in PHP.INI (extension=php_mysql.dll)
I have rebooted numerous times.
I then tried to web access MySQL (no old database) and got the message
Warning: PHP Startup: Unable to load dynamic library ‘./php_mysql.dll’ – the specified module could not be found.
Then in the browser I got
Fatal error: Call to undefined function mysql_connect() in
I then copied libmySQL.dll from Program files/MySQL/MySQL Server 4.1/bin to windows/system32
I got the same error.
I then copied libmySQL.dll from PHP and got the following error
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading
Any help would be appreciated. | |
|
|
|
| quote:
Originally posted by aurelius
Check:
http://dev.mysql.com/doc/mysql/en/Old_client.html
Z.
I have installed
mysql-4.1.7-essential-win.msi
php-5.0.2-installer.exe
I never had an earlier version of MySQL or PHP on this system since I had to rebuild it from scratch.
I took all the default options.
I did have to use the PHP version of LIBMYSQL.DLL (it was 228K in size)
I then issued the following commands through the web browser.
echo mysql_get_client_info();
phpinfo();
For MySQL I get 3.23.57 (this bothers me since I expected 4.1.7)
and PHP was at 5.0.2
The old password issue should not be a problem since I did not restore my database. I started from scratch. | |
|
| [QUOTE]Originally posted by aurelius
Check:
http://dev.mysql.com/doc/mysql/en/Old_client.html
Z. [/QUOTE
I finally solved my problem.
I found a link on the web for an early download of PHP 5.0.3
I made sure to move the new LIBMYSQL.DLL and MYSQL_PHP.DLL
to the windows/system32 folder.
I know it would be better to change the system path but since I don't know how to do that the system32 folder is the next best thing.
PHP 5.0.3 amd MySQL 4.1.7 now get along just great. | |
|
| Gerd I hope you come back because if you have that link for php 5.0.3 I sure could use it. I need it for a client site that is not working and I've done everything that all other forums have suggested. I'm running php 5.0.2 and MySQL 4.1.7 and I keep getting "Client does ..." same as always. So now I'm out of options and low on time. | |
|
| quote:
Originally posted by Wiz
Gerd I hope you come back because if you have that link for php 5.0.3 I sure could use it. I need it for a client site that is not working and I've done everything that all other forums have suggested. I'm running php 5.0.2 and MySQL 4.1.7 and I keep getting "Client does ..." same as always. So now I'm out of options and low on time.
I hope this helps.
Additional note: php-5.0.3-dev and newer ships with a newer version of the mysql library which does not have this problem. You can download it
at: http://snaps.php.net/win32/php5.0-win32-latest.zip |
|
|
|