Re: php-db Digest 7 Jun 2005 17:56:06 -0000 Issue 2973

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux