I have installed mysql and php on microsoft small business server/iis and I can remotely log in to the database with mysql administrator both with the root user and with a created user.
But when I try to connect via php on the same server it isnt possible.
<?
$link_id = mysql_connect("localhost", "hej", "hej");
//if (!$link_id){die("Unable to connect to database: ".mysql_error());}
?>
I get the answer:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in E:\deltalift.se\sqltest.php on line 10
Unable to connect to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client
What could the problem be?
