|
|
Posted by J.O. Aho on 03/08/06 10:58
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
Navigation:
[Reply to this message]
|