[RESOLVED] Problem connecting to MySQL dbase
hi,
I've got a simple php script on my local pc that's trying to connect to a MySQL database that runs on a seperate server. I'm using PHP v4.2.3 running on win XP and MySQL 5.0 running on a Win 2003 server:
PHP Code:
<html>
<head></head>
<body>
<?php
$x = mysql_connect( 'nuaire06', 'username', 'password' );
if (!$x) {
die('Could not connect: ' . mysql_error() );
}
echo "Connected Successfully";
//mysql_close($x);
?>
</body>
</html>
When the page displays, it doesn't connect to the database and I get the following message:
Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in ....... etc.
I know PHP works fine and the user/password combo for the dbase are correct as i connect to it using MySQL Administrator.
I've tried specifying the port number even though it's the default, as well as the ip addr of the server. Still no joy
Any help would be appreciated.
Aaron
