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

[Bryan J. Smith]

On Thu, 2002-04-18 at 09:06, Patrick McGovern wrote:
> 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 has root permissions yet the username for
> the mysql command is not root.  Is there a way to have mysql set the
> permissions to allow user access to that file?

Sounds like you're running that script as root, instead of the mysql
user.

Are you calling it via cronjob?  If so, you need to make sure you run it
from mysql's crontab, and not roots.
I.e., run "crontab -e" as the mysql user, not root.

-- Bryan

-- 
If consumers are liable to "correctly" license someone's IP, why aren't
IP holders held liable when they unjustly force the same consumers to
license the same IP more than once?  "Piracy" is a double-edged sword.
-----------------------------------------------------------------------
Bryan J. Smith, SmithConcepts, Inc            mailto:b.j.smith@ieee.org
Engineers and IT Professionals             http://www.SmithConcepts.com