Hi,
  I seem to have a mysql (or Php?) problem on one of my machines.
   
   I'm running OS 10.4.2 on both a G4 Quicksilver, and a 600MHz G3 14.1" iBook.

   Mysql and PHP are working fine on the iBook, not on the G4.

Here's info from the iBook:
 
iBook> fink list mysql
      dbd-mysql-pm560    2.1026-2    Perl5 Database Interface to MySQL
       dbd-mysql-pm581    2.9003-21    Perl5 Database Interface to MySQL
       libdbi-drivers-mysql    0.7.1-1    MySQL driver for libdbi
i     mysql    4.0.17-11    Open Source SQL database
i     mysql-client    4.0.17-11    Open Source SQL database - Client
i     mysql12-dev    4.0.17-11    Open Source SQL database - Development headers and libraries
i     mysql12-shlibs    4.0.17-11    Open Source SQL database - Shared libraries

iBook> mysql -V

mysql  Ver 12.22 Distrib 4.0.17, for apple-darwin7.8.0 (powerpc)
   

The same info from the G4:

G4> fink list mysql
 i     mysql    4.1.10-1    Open Source SQL database
i     mysql-client    4.1.10-1    Open Source SQL database - Client
i     mysql14-shlibs    4.1.10-1    Open Source SQL database - Shared libraries

G4> mysql -V
mysql Ver 14.7 Distrib 4.1.10, for apple-darwin7.9.0 (powerpc)

I updated the G4 while on 10.3.9, the behavior is unchanged on 10.4.2 -- it still doesn't work.

When I attempt to connect from php using mysql_connect(),   I get the error message:

Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client 

The output of mysql_client_info() is: 3.23.49 on both machines.

That seems to suggest something changed in the upgrade to mysql 4.1.10-1

The httpd.conf files on the two machines are equivalent.   I don' t think I'm using a Php.ini file on either machine.

What have I failed to read that I don't know how to proceed?

Mysql and Php were working fine on both machines until some upgrade I did, but I'm not sure which update it was.

Any clues appreciated.

joe

Reply via email to