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

Problem with load data infile and user's privileges

2002-06-15 Thread Sergey Bondar
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 DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(

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

Problem with load data infile and user's privileges

2002-06-14 Thread Sergey
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 DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(