Error 1148 and 1045

From: 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

« previous php.general (#167876) next »