I am still stuck with this bug. Can some one advise me, how to find out if I have the FILE privilege on my DB or not.
Thanks again Pushpinder
On Tuesday, January 6, 2004, at 12:08 PM, Michal Oskera wrote:
Hi, ensure you have FILE privilege on the db-server host.
Mike
"Pushpinder Singh" <[EMAIL PROTECTED]> píse v diskusním príspevku news:[EMAIL PROTECTED]Hello All,
I am trying to import data into MySQL DB using a CSV file (using
phpMyAdmin as the DB Admin tool). I keep getting the following error.
SQL-query :
LOAD DATA LOCAL INFILE '/tmp/phpYRmG0A' INTO TABLE `contacts` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'( `company` , `first_name` , `last_name` , `pri_practice` , `phone_1` , `city` , `state` )
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Here is the CSV file:
----------------------------------------------------------------------- -----
----
Any insights will be appreciated,,,, I had this thing working before but now I dont know why it seems to be acting up. Thanks in advance.
Pushpinder
-- 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