load data infile problem

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • moishyyehuda@gmail.com

    #1

    load data infile problem

    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)

  • Michael Hoffman

    #2
    Re: load data infile problem

    moishyyehuda@gm ail.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

    Comment

    Working...