[PHP] Error 1148 and 1045

[Steve Buehler]

I have upgraded my mysql  version to 3.23.58 and am coming up with a couple 
of errors using phpmyadmin to "Insert data from a textfile into table"  I 
didn't get this on the previous versions of mysql.  Here are the errors:

SQL-query :

LOAD DATA INFILE '/tmp/phpKFlQ2b' INTO TABLE `annsubscribers` FIELDS 
TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'(
`email`
)

MySQL said:

#1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

---------------

SQL-query :

LOAD DATA LOCAL INFILE '/tmp/phpsj1WGM' INTO TABLE `annsubscribers` FIELDS 
TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'(
`email`
)

MySQL said:

#1148 - The used command is not allowed with this MySQL version

---------------
Can anybody shed some light on how to fix this?  I presume the first is a 
permission problem that is from the new way that MySQL handles things.  The 
second is just a mystery to me.

Thanks
Steve
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php