MySQL Forums
Forum List  »  Security

LOAD DATA INFILE : Access Denied?
Posted by: Nathanael Noblet
Date: April 06, 2005 01:13PM

Hello,
I have a user to which I have the following privileges:

mysql.user:
'localhost','nedco','<REMOVED>','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0'

mysql.db:
'localhost','nedco_scratch','nedco','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y'
'localhost','nedco','nedco','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y'

Basically the only privilege it doesn't have is GRANT.

The file I am attempting to load is located in /tmp with permissions of 777. When attempting to load data I still get 'Access denied for user nedco@localhost using password yes'

Why?
Mysql Ver 4.1.7

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD DATA INFILE : Access Denied?
10001
April 06, 2005 01:13PM


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.