Posted by Farticus on 03/08/06 10:44

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

.... seems like I'm requesting from Apache instead of MySql server.

How can I rectify this problem?

Any ideas?

[Back to original message]