Posted by Farticus on 03/09/06 00:02

"J.O. Aho" <user@example.net> wrote in message
news:477kl6Fe3c2hU1@individual.net...
> Farticus wrote:
> > Hi,
> > I've installed Apache2, PHP4 and MySQL5 onto my XP box hoping to be able
to
> > devolop apps right where I sit. Yea, right!
> >
> > I've done this before without problems, but now my hairs turned white in
> > less than overnight.
> >
> > Individually all run just fine.
> >
> > When I write a PHP script and run it, it works OK.
> >
> > When I attempt to use MySql in the PHP it becomes a no-go zone.
> >
> > It appears that both Apache and MySql are localhost, so when I do:
> > $server = "localhost";
> > $userid = "blahblah";
> > $password = "password";
> >
> > mysql_pconnect($server,$userid,$password)
> > or die ("Could not connect to SQL server");
> >
> > .... I get this:
> > Warning: mysql_pconnect(): Client does not support authentication
protocol
> > requested by server; consider upgrading MySQL client in D:\Program
> > Files\Apache Group\Apache2\htdocs\contact51\index.php on line 51
> > Could not connect to SQL server
>
> client = php
> server = mysql
> The problem has nothing to do with your apache, it's just the "user" who
> executes php. You need to configure your mysql to not use authentication
and
> your problem is gone.
>
> If you want things to work out of the box without any problems, then
install
> an OS that includes apache, php and mysql as part of the applications
shipped
> with the OS.
>
>
> //Aho

Eventually found problem with MySQL passwords - new version has long
passwords etc. Did necessary then Flushed Priveleges and now all OK.
Thanks for your help.

[Back to original message]