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

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@lists.php.net 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@lists.php.net To unsubscribe from the digest, e-mail: php-db-digest-unsubscribe@lists.php.net To post to the list, e-mail: php-db@lists.php.net ---------------------------------------------------------------------- Date: Tue, 7 Jun 2005 09:25:58 -0300 From: Andrés G. Montañez <andresmontanez@gmail.com> To: php-db@lists.php.net Subject: Re: [PHP-DB] 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@lists.php.net From: "Wings" <glenn61@earthlink.net> Date: Tue, 7 Jun 2005 10:38:24 -0700 Subject: Re: [PHP-DB] Newbie with mail problem ""Andrés G. Montañez"" wrote in message news:652305240506070525145dc706@mail.gmail.com... 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@yahoo.com> To: php-db@lists.php.net 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@hotmail.com> To: scotthpowell@yahoo.com, php-db@lists.php.net Date: Tue, 07 Jun 2005 11:47:22 -0400 Subject: RE: [PHP-DB] 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@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 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@yahoo.com> To: Bastien Koert <bastien_k@hotmail.com>, php-db@lists.php.net Subject: 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 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 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@lists.php.net Date: Mon, 06 Jun 2005 23:19:10 -0500 From: Román Sánchez <romans@servidor.unam.mx> 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.