Hi Juan Pablo, LOAD DATE INFILE requires the FILE privelege, and the MySQL server process must have permissions to read the file in the named directory. Most times one or both of these requirements cannot be satisfied easily, particularly in a web environment.
You can get around both permissions issues using LOAD DATA LOCAL INFILE, which sends the contents of the infile over the MySQL socket to the MySQL server. In this case your running application (ie: apache, assuming PHP is running as a module) must have read permissions on the file, which is much easier to control. Regards, James >-----Original Message----- >From: Juan Pablo Herrera [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 10, 2004 4:15 PM >To: [EMAIL PROTECTED] >Subject: [PHP] Load Data > > >Hello! >I need a problem with mysql "Load Data". PHP say: "Access denied for user: >'[EMAIL PROTECTED]' (Using password: YES)", but my user and password is >correct.The sql query is: >$query_string2 = "LOAD DATA INFILE >'/usr/local/psa/home/vhosts/allaria.com.ar/httpdocs/XLS/precios' REPLACE >INTO TABLE precio FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES >TERMINATED BY '\n'"; >I used a vhost, what's a problem? > >Regards. >Juan Pablo > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
