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