Can't. upload files into tables.

[marbles]

I am using the following command to upload text files to a mysql database.

LOAD DATA INFILE "test.txt" into TABLE Suppliers.

My server returns the error message

Access denied (Using Password YES)

I have dozens of other PHP files that work correctly so I am confident that my script accesses the database & tables o.k.

I also have phpmyadmin running that also yields the same error message.

Does anyone know of any other command that will upload .txt or .csv files into my database fields.

Marbles.

[stevejacobsen]

I'd believe the error message. Check your permissions again. Make sure you are on the same server that the script is looking at. Also check the explicit permissions on the tables.

/steve

[marbles]

Hi. Steve,

I have been struggling with this problem for months. I appreciate you taking the time to reply.

I am out of my depth when it comes to checking server & table permissions.

What do I actually have to do & where do I do it. Is this problem anything to do with the set up of my phpMyAdmin config.ini file.

Regard, Marbles (Chris Norman).