Error 1148 and 1045

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

Steve Buehler wrote:
> 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:

[ snip ]

> ---------------
> 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.
>

This is a php mailing list. Ask your question on the mysql list.

--
Burhan Khalid
phplist[at]meidomus[dot]com
http://www.meidomus.com

Hi Steve,
I found you by putting the same error message into Yahoo--it took me to
your post. Since there was no reply, I was wondering if you could shed
some light if you found a remedy to the upload issue. I get the exact same
errors..Please let me know if you found a solution.
Thank you
gzakes@adelphia.net




Steve Buehler wrote:


> 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 'rn'(
> `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 'rn'(
> `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





##-----------------------------------------------#
Article posted from PHP Freaks NewsGroup
http://www.phpfreaks.com/newsgroup
Get Addicted: php.genera
##-----------------------------------------------##