weird Error

[abels28]

i am receiving and weird error in my connect script:

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in M:\1-Web Site\DebuggingVersionInPHP_debug_tmp.php on line 7

my script looks like this except there are letters instead of ****:

<?php

define('db_user', 'root');
define('db_host', '');
define('db_password', '***');
define('db_name', '***');

$dbc = mysql_connect( '', db_user, db_password);

mysql_select_db(db_name);

?>

I have apache, mysql, and php running on my local machine and that is how i am attepting to debug. I know that there is no user called ODBC and i am not assigning that variable. I don't know where it would come from. Any Ideas?

[Kudose]

Well, then your username and password aren't being passed.
Try this....also setting a host location.

<?php

define('DB_USER', 'root');
define('DB_HOST', 'localhost');
define('DB_PASS', '******');
define('DB_NAME', '******');

$dbc = mysql_connect(DB_HOST, DB_USER, DB_PASS);

if($dbc){
mysql_select_db(DB_NAME);
} else {
echo mysql_error();
}

?> 

[abels28]

That worked and got rid of that error but now it is throwing some others:

<?php

define('db_user', 'root');
define('db_host', 'localhost');
define('db_password', '***');
define('db_name', '***');

$dbc = mysql_connect( db_host, db_user, db_password);

if($dbc){
mysql_select_db(db_name);
} else {
echo mysql_error("test");
}
//mysql_select_db(db_name);

?>

these are what it is throwing now:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs_debug_tmp.php on line 8

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Group\Apache2\htdocs_debug_tmp.php on line 13

[abels28]

scratch that second error, that just meant i couldn't send a string to the error funtion

[Kudose]

Can you conntect when replacing the defined variables with strings?

[abels28]

i was reading some posts on another site and it told me that the config on the mysql wasn't right and to log into mysql using the windows run command and then use the line:

SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something');

where username=peter
where host = localhost
where password = something

this worked great. Thanks for your help though. I really appreciate it.