-----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 6:55 AM To: [EMAIL PROTECTED] Subject: re: RE: load data infile question
Hi! >On Tuesday 25 March 2003 19:54, Salada Duncan wrote: > >> I was able to work around the problem by giving "insert" privileges to the >> user for the WHOLE database. This is definitely not optimal because I only >> wish this user to be able to insert into one table in the database. But as >> soon as I gave the user insert privileges for the whole database the "load >> data infile" command worked. This seems like a bug to me, perhaps it has >> been dealt with in newer versions though. > >It works fine for me on 3.23.56. Could you upgrade MySQL server and test on >the 3.23.56? Thanks for the suggestion to upgrade Victoria. It jogged my memory that our development server had a copy of 3.23.54 (we recently upgraded it to 4.0.12 in prepration for moving to 4 for production). I fired up 3.23.54, and everything worked as planned. So, it seems this isn't a problem in 3.23.54. Sorry to take up your time. Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
