[linux-help] Re: Mysql permissions

[Jeff Vian <jvian10@xxxxxxxxxxx>]

 From the documentation for MySQL I found the following

    "The |FILE| privilege gives you permission to read and write files
    on the server using the |LOAD DATA INFILE| and |SELECT ... INTO
    OUTFILE| statements. Any user to whom this privilege is granted can
    read or write any file that the MySQL server can read or write."

If I am reading this correectly, the MySQL server must have permission 
to read/write the file you are trying to write to.  Thus the outfile 
would need to be in a location where the server has permissions to 
write.  It would appear the file written is not dependent upon the users 
permissions (other than the granted privleges) but rather on the servers 
permissions.



bruce bales wrote:

>Steven Saner wrote:
>
>  
>
>>In order to do this you must have "FILE" privileges. Try issuing
>>something like:
>>
>>GRANT FILE ON table_name TO username;
>>
>>Steve
>>
>>    
>>
>I signed on as root and tried to do that.  Got "Illegal grant command." 
> Tried the same as Linux ROOT and got the same result.
>---------------------------------start-----------------------------
>[bruce@bertha temp]$ mysql -u root -p
>Enter password:
>Welcome to the MySQL monitor.  Commands end with ; or \g.
>Your MySQL connection id is 33 to server version: 3.23.56-log
>
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>mysql> use class50;
>Database changed
>mysql> grant file on class to bruce;
>ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual 
>which privileges can be used.
>--------------------------------end-----------------------------------
>Then I tried:
>
>mysql> grant file on * to bruce;
>Query OK, 0 rows affected (0.01 sec)
>
>But when I tried to use the outfile I got the  "Access denied for bruce."
>
>-- This is the linux-help@xxxxxxxxx list.  To unsubscribe,
>visit http://www.complete.org/cgi-bin/listargate-aclug.cgi
>
>
>  
>

-- This is the linux-help@xxxxxxxxx list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi