Hi,
Im a newbie with both php and MySql.
I got php 4.4.0 and MySql 4.1.14 installed on a IIS 6.0.
I do not have myODBC installed.
Php is working on server.
MySql is up and running, can connect via MySql Administrator.
But I can not connect with PHP!
I downloaded this code:
$mysql_host = "localhost";
$mysql_database = "artest";
$mysql_user = "root";
$mysql_password = "mypass";
$conn = mysql_connect($mysql_host, $mysql_user, $mysql_password);
if (!$conn)
{
exit("Connection failed: " . $conn);
}
echo("Connection successfull.");
Gets this errmess:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot\PHP\mysql\php_till_mysql\php_till_mysql.php on line 5
When I try phpinfo.php I get the mess of SQL Client API Version: 3.23.49 but that doesn't mean anything to me...
Can somebody please help me how to connect to MySQL with PHP?
