HELP!! Access Denied with LOAD DATA

[Anon]

Hello I am doing a LOAD Data Query and I keep getting the following error:

Access denied for user: 'bigvalue@localhost' (Using password: YES)

• the username is the only username/password for the DB

• I can do SELECT , DELETE, MODIFY queries with no problem

• The File I am loading is &&& (also tried 755) and the owner has the same username as the user of the DB

• I can do a LOAD DATA Query from the MySql prompt, or through the phpMyAdmin the hosting company offers.

Can some one please look at my code and give me an idea whats wrong??

<?php
//Load new file into Staging Database - PE_Tigerdirect
$db_name ="bigvalue";
$connection = mysql_connect(localhost,username,pass) or die("Couldn't Connect to Bigvaluezone Database");
$db = @mysql_select_db($db_name, $connection) or die("Couldnt select database.");
$query_b = "LOAD DATA LOCAL INFILE '/home/bigvalue/public_html/price_engine/loader/tigerdirect/tigerdirect.csv' INTO TABLE PE_Tigerdirect FIELDS TERMINATED BY ',' ENCLOSED BY '\"' IGNORE 1 LINES";

$result_b 		= mysql_query($query_b);
 				echo mysql_error () ;    			
$rows_b			= mysql_affected_rows()
			or die("-PROCESS FAILED error getting row count from Staging Database - PE_Tigerdirect<BR>");

// Error
if ($rows_b == -1) {
print "-PROCESS FAILED error loading tigerdirect into Staging Database - PE_Tigerdirect<BR>";
die;
} else {	
print "-Records loaded into Staging Database - PE_Tigerdirect<BR>";
}

?>

[Anon]

My answer may be dumb, but this has happened sooo many times to me, too. The reason for me is ALWAYS that I have misspelled/mistyped the database.

Also, make SURE what you THINK your, "username" is, is actually the correct username.

For example, lets say my website is blahblahblah.com and I "pick" the username, "billybob."

Okay.... you may THINK your username is "billybob," but your webhost/server/whoever might create your username as:
blahblahblah_billybob

At least that's how one of my servers does it. It appends my site and an underscore onto the username I select.

[Anon]

I tried that and no dice

in fact I am able to do SELECT DELETE & MODIFY queries with the same u/p, also I have copied and pasted the db connect script from my other scripts.

Any ideas