Re: Mysql permissions

In order to do this you must have "FILE" privileges. Try issuing
something like:

GRANT FILE ON table_name TO username;

Steve


On Sun, Aug 24, 2003 at 08:53:54PM -0500, bruce bales wrote:
> I have been trying tolearn mysql for a couple of weeks.  I am able to 
> create databases and tables and fill the columns with the load command. 
>  I can select pieces and parts to the screen.  I can insert and delete 
> rows. But I can only select to a file if I am the mysql root user.
> 
> As user bruce,  I get 'access denied.
> 
> mysql> use class50
> Database changed
> mysql> select * into outfile 'email.dat' fields terminated by ',' from 
> emailaddr;
> ERROR 1045: Access denied for user: 'bruce@localhost' (Using password: YES)
> mysql>
> 
> When I use the above as mysql root it puts the data in 
> /var/lib/mysql/class50/email.dat.
> 
> I get the same when I try to put it into one of my own directories with:
> mysql> select * into outfile '/home/bruce/temp/email2.dat' fields 
> terminated by ',   ' from email;
> 
> I have studied the O'Reilley book and a good tutorial on mysql.com and 
> can't find anything relevant to this.  I set up my user bruce password 
> as below and it works for logging in to mysql.
> 
> AS ROOT:
> mysql> grant all on class50.* to bruce identified by 'augie06' ;
> Query OK, 0 rows affected (0.00 sec)
> 
> Any help would be appreciated,
> bruce
> 
> 
> 
> -- This is the [email protected] list.  To unsubscribe,
> visit http://www.complete.org/cgi-bin/listargate-aclug.cgi

-- 
--------------------------------------------------------------------------
Steven Saner <[email protected]>
-- This is the [email protected] list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi