All,
i had a PHP 3.x and early mysql instalaltion. As I moved computers I installed PHP 4 - latest available and Apache 1.3.x latest available. I also have MYsql 4.1.5.
Almost everything works - not without huge pain, but in my old code I had a very siimple include proc that allowed me to connect to the database which looked like this:
#initilise variables
$db = "dummy";
mysql_select_db($db);
That always let me connect no problems. But now I get the following error message:
Warning: mysql_select_db(): Access denied for user 'ODBC'@'localhost' (using password: YES) in C:\Program Files\Apache Group\Apache\htdocs\inc_db_connect.inc on line 16
So I did some reading and added the following code which is:
#initilise variables
$link = mysql_connect('localhost','usr','pwd');
$db = "dummy";
mysql_select_db($db,$link);
Which then gives me:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache\htdocs\inc_db_connect.inc on line 14
If I am honest I am not sure what the username and password should be as I did a default MYSQL installation and took all defaults they requested.
the upshot is that I cannot connect to my database.
Any and all suggestions are gratefully received. Thank you all very much in advance.
regards
Antoine
