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
