I’m having a hard time getting my php script to connect to mysql properly,
the php script consists of the following code:
<?php
mysql_connect(“localhost”,”root”,”password”)
or die (“Could not connect to database”);
mysql_select_db(“menagerie”)
or die (“could not select database”);
echo “All tasks successful”;
mysql_close();
?>
When I run the page, I get this error:
[B]Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /Users/me/Sites/testing/sql_mena.php on line 8
Could not connect to database
I’m on an iMac (OS X 10.3.3)
PHP Version 4.3.2
MySQL Version 4.1.10 -standard
Any help would be greatly appreciated