View Single Post
  #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
==================
Reply With Quote