Please explain Grants & Privileges

[Boss Hoss]

and how users should be setup in phpMyAdmin. If I want user "mycdtca" to be able to run the SQL command "LOAD FILE ..." what do they need to be setup as for "localhost"?

I keep getting the error "Access denied for user: 'mycdcta@localhost' (Using password: YES)" trying to run the following SQL in a php script.

LOAD DATA INFILE '/home/virtual/site3/fst/var/www/html/horsetrials/times.csv' REPLACE INTO TABLE `springht_data` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r' IGNORE 1 LINES

which I can get to run through phpMyAdmin logged in as root. I can also get the SQL command to run through the php script if I connect as ROOT user to localhost..so the problem is with my user mycdcta.

Host localhost - User mycdcta 
Action	Database 	Table 	Privileges	Grant Option
Revoke Privileges 	Revoke Grant 	All	All	ALL PRIVILEGES	Yes
Revoke Privileges 	`mycdcta%`	All	SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER	No
Revoke Privileges 	`cdcta_com`	All	SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER	No
Revoke Privileges 	Revoke Grant 	`cdcta\_com`	All	ALL PRIVILEGES	Yes

I don't have tables "mycdcta%" or "cdcta\_com" but I get errors trying to revoke these lines?

REVOKE SELECT , 
INSERT ,
UPDATE ,
DELETE ,
CREATE ,
DROP ,
INDEX ,
ALTER ON `` mycdcta % `` . * FROM 'mycdcta'@ 'localhost' 

MySQL said: 

You have an error in your SQL syntax near 'mycdcta%``.* FROM 'mycdcta'@'localhost'' at line 1

[nickc]

Passwords are case senstive. Is the password Yes or YES?

Nick

[Boss Hoss]

uhh..that's just a message saying that a password was expected right?