in m > <mailto:ka...@el.net>> wrote:
> >
> >
> >
> > hi...
> >
> > so i have this user in the user table in the mysql db that has all
> the
> > privileges but "grant". now i need for that user to have the "file"
s, "db" is
> specific to each database.
>
> Carlos
>
>
> On Mon, Jan 30, 2012 at 10:56 PM, kalin m <mailto:ka...@el.net>> wrote:
>
>
>
> hi...
>
> so i have this user in the user table in the mysql db that has all the
> pr
leges but "grant". now i need for that user to have the "file"
> privilege so it can do "into outfile". thing is i don't see that
> privilege anywhere in the db table. i know that i have to do the "grant
> file on user@localhst" thing but what tabl
hi...
so i have this user in the user table in the mysql db that has all the
privileges but "grant". now i need for that user to have the "file"
privilege so it can do "into outfile". thing is i don't see that
privilege anywhere in the db table. i know that i
Thank you for the fine bug report.
We shall fix it soon.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ w
I give file access to a user on tables in a database :
GRANT INSERT,SELECT,FILE ON LOGS.* TO www@localhost identified by
'hidden';
then :
SHOW GRANTS www@localhost;
+---+
| Grants for www@localhost
>Description:
Granting a normal user FILE privilege will be listed as DROP
and user has both FILE and DROP privileges.
>How-To-Repeat:
mysql -u root -p
CREATE DATABASE TEST1;
USE TEST1;
CREATE TABLE TESTING (COL1 CHAR(3) );
GRANT INSERT,
