Posted by BJA on 06/27/05 00:24

Help please.
I am a complete newbie, so be kind. Trying to connect to MySQL via the PHP
script below

<?php
$link = mysql_connect('localhost', 'Username', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully;
mysql_close($link);
?>
I get the following message

Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in C:\www\test4.php on
line 12

I set up another account on MySQL without a password and using the same
script but with a blank password it connects fine.

So I know that I can connect to MySQL via my server(Apache) but not with
passwords, which isn't that secure ;-))

I have PHP4, MySQL 4.1.12a-nt and Apache 2.0.3

I have looked everywhere I can think of but cannot find an answer.

[Back to original message]