|
|
Posted by jukka on 03/08/06 21:56
J.O. Aho wrote:
> 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
maybe pconnect doesn't work for you, try mysql_connect(), that will
probably work :)
Navigation:
[Reply to this message]
|