RE: [PHP-DB] Cannot connect to local MySQL -- Client does not support authentication protocol
MySQL's instructions, while 'clear'(upgrade the client library), don't tell
you where to get the damn library. If anyone has a link to the new mysql
client libraries, I'd appreciate it.
I tend to simply downgrade the password string to the old 16bit style
run this command:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Bastien
From: Scott Powell [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Cannot connect to local MySQL -- Client does not support
authentication protocol
Date: Tue, 7 Jun 2005 07:43:23 -0700 (PDT)
I am trying to set up my laptop to run PHP and MySQL together.My system
summary is:Win 2000 (localhost)PHP 4.3.11MySQL Server 4.1.12MySQL Client
5.0.0MySQL Admin 1.0.9I can connect to my local MySQL host using MySQL
client tools.I can connect to a remote MySQL server (don't know the exact
version) from PHP in a very simple connect/select template.But I cannot
connect to my local MySQL Server from my local PHP installation.Using
phpMyAdmin version 2.2.7-pl1, the error message is:MySQL said: Client does
not support authentication protocol requested by server; consider upgrading
MySQL clientPHP BB gives a similar message:Warning: mysql_connect():
Client does not support authentication protocol requested by server;
consider upgrading MySQL client in c:\inetpub\wwwroot\phpbb2\db\mysql4.php
on line 48Can anyone suggest how to solve this problem? I've spent the
better part of every evening for th epast week trying to get PHP and MySQL
to work...I'm at wits end.ThanksScott
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Cannot connect to local MySQL -- Client does not support authentication protocol
I tried the use old passwords flag in the my.ini file. That has completely
crashed out the Admin GUI (GPF writing to ntdll.dll) and not corrected the
problem.
I'll try this too.
Bastien Koert [EMAIL PROTECTED] wrote:
MySQL's instructions, while 'clear'(upgrade the client library), don't tell
you where to get the damn library. If anyone has a link to the new mysql
client libraries, I'd appreciate it.
I tend to simply downgrade the password string to the old 16bit style
run this command:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Bastien
From: Scott Powell
To: php-db@lists.php.net
Subject: [PHP-DB] Cannot connect to local MySQL -- Client does not support
authentication protocol
Date: Tue, 7 Jun 2005 07:43:23 -0700 (PDT)
I am trying to set up my laptop to run PHP and MySQL together.My system
summary is:Win 2000 (localhost)PHP 4.3.11MySQL Server 4.1.12MySQL Client
5.0.0MySQL Admin 1.0.9I can connect to my local MySQL host using MySQL
client tools.I can connect to a remote MySQL server (don't know the exact
version) from PHP in a very simple connect/select template.But I cannot
connect to my local MySQL Server from my local PHP installation.Using
phpMyAdmin version 2.2.7-pl1, the error message is:MySQL said: Client does
not support authentication protocol requested by server; consider upgrading
MySQL clientPHP BB gives a similar message:Warning: mysql_connect():
Client does not support authentication protocol requested by server;
consider upgrading MySQL client in c:\inetpub\wwwroot\phpbb2\db\mysql4.php
on line 48Can anyone suggest how to solve this problem? I've spent the
better part of every evening for th epast week trying to get PHP and MySQL
to work...I'm at wits end.ThanksScott
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
