Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > Load Data Infile question
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 3rd July 23:05
External User
 
Posts: 1
Default Load Data Infile question


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)
  Reply With Quote


  sponsored links


2 3rd July 23:05
jerry stuckle
External User
 
Posts: 1
Default Load Data Infile question


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
3 3rd July 23:05
External User
 
Posts: 1
Default Load Data Infile question


If I am using phpMyAdmin, how would I execute the command "mysql
--local-infile" ?
  Reply With Quote
4 3rd July 23:05
jerry stuckle
External User
 
Posts: 1
Default Load Data Infile question


AFAIK, you don't. There may be a SET option, but I'm not sure what it is.

You would have to start mySql with the --local-infile option. Since you're
using phpMyAdmin, you may have to compile PHP against the current version of
MySQL - but not knowing which version of either you're using, I have no idea.

You may be able to get it to work with LOAD DATA LOCAL INFILE ... but I haven't
tried it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666