Cannot connect to Dbase

hansalas

$location="localhost";
$username="root";
$password="test";  

$db=mysql_connect($location,$username,$password);

if ($db)
{
print 'Yahoooo!! I am in.';
exit;
}
else
{
print "Tell me Why?".$db."end";
exit;
}

The result i get is Tell my Why?end
the $db doesnt print.

my configuration
Win 2K
MySql server 4.1.7
PHP Version 4.3.11
Windows IIS

Thanks guys ...

php4ever

only thing I can think of is that your mysql is not set up properly. This is what I use to connect...if it helps :

mysql_connect("localhost","user","pass") or
die("Could not connect!!^{_^"} . mysql_error());
mysql_select_db("ccsn");

//Only thing I see is that you're not selcting a database?

hansalas

mysql_connect("localhost","user","pass") or 
die("Could not connect!!^_^" . mysql_error());

the error msg i received is this.....

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Thanks guys.

My configuration is

IIS
Win 2K
MySQL 4.1.7
PHP Version 4.3.11

mrhappiness

if you can use mysqli instead of mysql: use it

if you can't: either downgrade mysql to 3.x or tell it to use the old password scheme

read more about it here: http://dev.mysql.com/doc/mysql/en/old-client.html

hansalas

THanks man.. Owe U a million..

Used this to solve the probs...

SET PASSWORD FOR 'user'@'localhost'=OLDPASSWORD('newpwd');