What are the permission in your /var/lib/mysql/mysql directory?
here's what I get:
mysql> load data local infile '/usr/local/var/db/mysql/mysql/user.MYD' into
table t;
ERROR:
File '/usr/local/var/db/mysql/mysql/user.MYD' not found (Errcode: 13)
mysql>
and here is the file
[dev-405:andrew] ...var/db/mysql (8) # ll
/usr/local/var/db/mysql/mysql/user.MYD
-rw-rw---- 1 mysql mysql 1498 Jun 29 14:29
/usr/local/var/db/mysql/mysql/user.MYD
[dev-405:andrew] ...var/db/mysql (9) #
thanks,
-- Andrew
----- Original Message -----
From: "Jose de Leon" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 6:01 AM
Subject: Re: Looks like any user can read the mysql db!
> This is what I did:
>
> load data local infile '/var/lib/mysql/mysql/user.MYD' into table data;
>
> At first I did it without the 'local' keyword. But with 'local' keyword
it works.
>
>
>
> ======================================
> On Wed, 15 Aug 2001 14:51:44 -0400
> "Andrew Schmidt" <[EMAIL PROTECTED]> wrote:
>
> > I'm not sure how you were able to do that. Especially since you didn't
> > provide exactly what you did.
> >
> > But here's what I get as ROOT (all privileges):
> >
> > mysql> load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into
table
> > t;
> > ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must be in
the
> > database directory or be readable by all
> > mysql>
> >
> > since all mysql datafiles are 660 (not readable by all) and do not sit
in
> > the database directory I'm not sure how you would read in those tables.
> >
> > The only thing I was able to read in was the .err file
> >
> > perhaps you can explain in more detail what you did?
> >
> > thanks,
> >
> > -- Andrew
> >
> > ----- Original Message -----
> > From: "Jose de Leon" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, August 16, 2001 5:03 AM
> > Subject: Looks like any user can read the mysql db!
> >
> >
> > > MySQL 3.23.36
> > >
> > > Using the LOAD DATA command, I was able to read the first field of
> > user.MYD. I think I should
> > > be able to load the rest of the table with a little bit of playing
> > around...
> > >
> > > I think with a little bit of ingenious delimeter specification, etc,
> > anybody should be able to
> > > load any table they want provided they know the path.
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
