Re: Problem with load data infile and user's privileges

2002-06-15 Thread Jason Englehardt
On Sat, 15 Jun 2002, Sergey Bondar wrote: > OS Linux Red Hat 7.2 > MySql 3.23.41 > > Hi All! > That is my steps. > > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK The user needs the file privilege. Granting all on mydb.* does not giv

Re: Problem with load data infile and user's privileges

2002-06-14 Thread Paul DuBois
At 20:23 -0400 6/14/02, Sergey wrote: >OS Linux Red Hat 7.2 >MySql 3.23.41 > >Hi All! >That is my steps. > >With root privileges >I doing: >GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; >I got: >OK > >With client privileges !!! >I doing: >mysql -u client -p >passwd >CREATE DATAB

Re: Problem with load data infile and user's privileges

2002-06-14 Thread Galen Wright-Watson
On Fri, 14 Jun 2002, Sergey wrote: > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK > > > Then I doing: > LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; > I got: > ERROR 1045 Access denied fot user: 'client@localhost' (Using

Re: Problem with LOAD DATA INFILE

2001-12-31 Thread David J Jackson
Are you using mysqlimport utility? If not that may be you answer? If so what flags are you setting? david > HI ALL: Happy New Year ;) > I have a text file generated from MSAccess database, one of the > fields (Long Text) have Carriage returns within the text, So > the data of some records f

RE: Problem with LOAD DATA INFILE

2001-10-31 Thread Rick Emery
I suggest writing a PERL script/filter which accepts the text file and sends a comma-delimited file to standard-out. This file could then be sucked in by mysql -Original Message- From: Michael Benbow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 7:48 PM To: [EMAIL PROTECTED