Garayed.com  

Go Back   Garayed.com > mySQL
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-22-2006, 08:50 PM
Jerry Stuckle
 
Posts: n/a
Default Re: Load Data Infile question

bradfordh@gmail.com wrote:
> I just tried to execuete a Load Data Infile command to import data from
> a .cvs file into a mysql table, but I get the following error. Any help
> at all is greatly appreciated. Thanks
>
>
>
> #1045 - Access denied for user 'number11'@'localhost' (using password:
> YES)
>


My guess would be that number11@localhost doesn't have 'file' authorization for
this database.

Alternatively, it could be if you're using a recent version of MySQL which has
local infile support disabled by default. To change this, you must use:

mysql --local-infile

And BTW - did you try a google search? One on

"LOAD DATA INFILE" mysql 1045

showed several possibilities.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-23-2006, 12:48 AM
bradfordh@gmail.com
 
Posts: n/a
Default Re: Load Data Infile question

If I am using phpMyAdmin, how would I execute the command "mysql
--local-infile" ?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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

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



All times are GMT. The time now is 09:04 PM.




LinkBacks Enabled by vBSEO 3.0.0 © 2007, Crawlability, Inc.