Error 1148 and 1045
| From: | Steve Buehler | Date: | Tue, 28 Oct 2003 14:57:47 +0000 |
| Subject: | Error 1148 and 1045 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-167876@lists.php.net to get a copy of this message | ||
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: 'animalnews@localhost' (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