load data infile problem

Michael Hoffman cam.ac.uk at mh391.invalid
Sun Jun 10 19:25:41 CEST 2007


moishyyehuda at gmail.com wrote:
> does any one know why when I execute this mysql statement with python
> api
> 
> LOAD DATA INFILE  'data.txt' INTO TABLE merchandise;
> 
> I get this error and how can I fix it
> 
> #1045 - Access denied for user: 'papermen@%' (Using password: YES)

This has nothing to do with Python. It is obvious from the error that 
the user "papermen" doesn't have the privileges to load data into that 
table. Ask your database administrator to give you the appropriate 
privileges.

Followups set.
-- 
Michael Hoffman



More information about the Python-list mailing list