still cant figure it out on connection

muss2000nline

Hello guys,
I've browse through, and found couple of articles on the connection for newbie,... still i cant find way to accomplish it. Below is my code, a simple code:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>PHP/MySQL</title>
<?php
$link = mysql_connect('localhost', 'root', 'password') or die('Could not connect');
echo 'Connected successfully';
?>
</head>
<body>
</body>
</html>

The error received:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Program Files\Apache Group\Apache2\htdocs\myTesting\index.php on line 6
Could not connect

My testing environment:
Apache 2.0.52
MySQL Server 4.1
php-4.3.10-Win32

Please respond asap...
.muss

Norman_Graham

Hi Muss

I could be wrong - and I can't test it here - but I suspect you can't put the DB connect stuff in the file headers.

As a general rule, avoid wherever possible putting PHP slap bang in the middle of HTML tags unless there is a compelling reason to do so. I recommend you put all your DB-connect stuff in an include file and use include() or require_once() at the start of the file.

For now, put your DB connection either before or after the <head></head> tags, but not in the middle. This might solve your problem.

HTH

Norm