load data infile problem

This is a discussion on load data infile problem within the MySQL Database forums, part of the Database Forums category; does any one know why when I execute this mysql statement with python api LOAD DATA INFILE 'data.txt' INTO ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-10-2007
moishyyehuda@gmail.com
 
Posts: n/a
Default 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)

Reply With Quote
  #2 (permalink)  
Old 06-10-2007
Michael Hoffman
 
Posts: n/a
Default Re: load data infile problem

moishyyehuda@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
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:59 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0