[KLUG Members] mysql writes to a file with root permissions

[members@kalamazoolinux.org]

>I am using a mysql one line command within a shell script.  It extracts data
>from an sql script and the output is redirected to a file.  The output file

"extracts data from an sql script"?

Do you mean the script performs an sql query and writes the result set to a file?

>has root permissions yet the username for the mysql command is not root.  Is

Are you running the script as root?

>there a way to have mysql set the permissions to allow user access to that
>file? 

If the script is run as root you can chown/chmod to any permissions you desire.