MySQL Forums
Forum List  »  MySQL Administrator

LOAD DATA INFILE WORKS FOR SOME USERS
Posted by: Charles Norton
Date: February 01, 2011 07:09AM

One of my users can perform a LOAD DATA INFILE. Another user cannot.

I have looked at each user's privileges, but cannot see why one user can perform the load, while the other cannot.

This is the error:

ERROR 1045 (28000): Access denied for user

Neither user in question is root.

Which permissions should I look at to see why this error is occurring?

I have looked at the obvious things like whether or not a user has the permissions to load the file in question. I put the file in /tmp, and its permissions are fine.

By the way, I do know about load data local, but load data works for one user, and not for the others. I'm still perplexed.
Thanks.
cmn

Data Processing Department
Town of Arlington
Arlington, MA



Edited 1 time(s). Last edit at 02/01/2011 07:38AM by Charles Norton.

Options: ReplyQuote


Subject
Written By
Posted
LOAD DATA INFILE WORKS FOR SOME USERS
February 01, 2011 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.