From: Scott Powell <scotthpowell@xxxxxxxxx>
To: php-db-digest-help@xxxxxxxxxxxxx, php-db@xxxxxxxxxxxxx
Subject: Re: php-db Digest 7 Jun 2005 17:56:06 -0000 Issue 2973
Date: Tue, 7 Jun 2005 22:42:18 -0700 (PDT)
Bastien,
That seems to have worked. I can see php admin's home page. And it looks
like PHP BB got installed.
I understand the error message (basically, the compiled-in library is out
of date with the server) but it could be A LOT clearer...it sounds like the
MySQL client libraries are out of date and they're not.
I know PHP and the other tools are all free. But this is a pretty basic
compatibility issue that could be VERY easily documented right in the
install file for PHP 4.x: if you are using version x.y or greater of MySQL,
please be sure... would go a long way to eliminating this confusion.
Thanks
Scott
php-db-digest-help@xxxxxxxxxxxxx wrote:
php-db Digest 7 Jun 2005 17:56:06 -0000 Issue 2973
Topics (messages 39594 through 39599):
Re: Newbie with mail problem
39594 by: Andrés G. Montañez
39599 by: Wings
Cannot connect to local MySQL -- Client does not support authentication
protocol
39595 by: Scott Powell
39596 by: Bastien Koert
39597 by: Scott Powell
39598 by: Román Sánchez
Administrivia:
To subscribe to the digest, e-mail:
php-db-digest-subscribe@xxxxxxxxxxxxx
To unsubscribe from the digest, e-mail:
php-db-digest-unsubscribe@xxxxxxxxxxxxx
To post to the list, e-mail:
php-db@xxxxxxxxxxxxx
----------------------------------------------------------------------
Date: Tue, 7 Jun 2005 09:25:58 -0300
From: Andrés G. Montañez <andresmontanez@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: Newbie with mail problem
Use a real hostname, not 'localhost'.-
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay
To: php-db@xxxxxxxxxxxxx
From: "Wings" <glenn61@xxxxxxxxxxxxx>
Date: Tue, 7 Jun 2005 10:38:24 -0700
Subject: Re: Newbie with mail problem
""Andrés G. Montañez"" wrote in message
news:652305240506070525145dc706@xxxxxxxxxxxxxxxxx
Use a real hostname, not 'localhost'.-
Will give that a try. Thank you.
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay
Date: Tue, 7 Jun 2005 07:43:23 -0700 (PDT)
From: Scott Powell <scotthpowell@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Cannot connect to local MySQL -- Client does not support
authentication protocol
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 client"PHP 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 48"Can 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 From: "Bastien Koert" <bastien_k@xxxxxxxxxxx>
To: scotthpowell@xxxxxxxxx, php-db@xxxxxxxxxxxxx
Date: Tue, 07 Jun 2005 11:47:22 -0400
Subject: RE: Cannot connect to local MySQL -- Client does not
support authentication protoco
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@xxxxxxxxxxxxx
>Subject: 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 client"PHP 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 48"Can 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
Date: Tue, 7 Jun 2005 08:54:06 -0700 (PDT)
From: Scott Powell <scotthpowell@xxxxxxxxx>
To: Bastien Koert <bastien_k@xxxxxxxxxxx>, php-db@xxxxxxxxxxxxx
Subject: RE: 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 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@xxxxxxxxxxxxx
>Subject: 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 client"PHP 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 48"Can 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 To: php-db@xxxxxxxxxxxxx
Date: Mon, 06 Jun 2005 23:19:10 -0500
From: Román Sánchez <romans@xxxxxxxxxxxxxxxx>
Subject: Re: Cannot connect to local MySQL -- Client does not support
authentication protoco
I think it is not just a matter of upgrading the library. You can get it
if I remember well from the source distribution of MySql. The problem is
that PHP comes pre-compiled with the older MySql client version so you
would need recompile PHP.
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
