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.
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.
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
I don't have tables "mycdcta%" or "cdcta\_com" but I get errors trying to revoke these lines?
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
REVOKE SELECT ,
ALTER ON `` mycdcta % `` . * FROM 'mycdcta'@ 'localhost'
You have an error in your SQL syntax near 'mycdcta%``.* FROM 'mycdcta'@'localhost'' at line 1