[GRLUG] cron job an password

[Michael Glaske]

Pass it a config file that has the password in it, make the file read only
root.

mysqldump --defaults-file=/etc/mysql/my.cnf

put in my.cnf  (any of these is optional)
[mysqldump]
user = username
password = password
socket =
port =
host =


On Tue, Jun 11, 2013 at 9:44 AM, Eric Beversluis <
ebever at researchintegration.org> wrote:

> How can I set a cron job to do mysqldump without hardcoding the mysql
> root password into the cron command? (It looks like anyone can read the
> various cron files.)
>
> _______________________________________________
> grlug mailing list
> grlug at grlug.org
> http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shinobu.grlug.org/pipermail/grlug/attachments/20130611/37439669/attachment.html>