[linux-help] Re: Mysql permissions

[bruce bales <bbales@xxxxxxx>]

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