-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

Zbigniew Szalbot wrote:

| It works so no problem but I do not really like the idea of providing
| passwords in crontab. I wish the option in my.cnf file worked as
| advertised.

Hmmm.... It's always worked for me to create a file /root/.my.cnf containing:

[client]
user = root
password = imnottellingyou

Make sure that's mode 400.  You should then be able to type 'mysql' as the unix
root user and be auto-logged into a root level mysql session without having to
type in the password explicitly.  Other client applications (mysqldump, 
mysqladmin,
mysqlcheck etc.) will work similarly.  Note that you want to run
'mysql_secure_installation' or otherwise get rid of remote root level access to
MySQL to ensure security.

        Cheers,

        Matthew

- -- Dr Matthew J Seaman MA, D.Phil. Flat 3
~                                                      7 Priory Courtyard
PGP: http://www.infracaninophile.co.uk/pgpkey         Ramsgate
~                                                      Kent, CT11 9PW, UK
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEAREDAAYFAkjttr0ACgkQ3jDkPpsZ+VYYdQCfX/ZZqS9gb0HARekVm/rn/nYd
za8An02zwJl2QBO3q9kFVgcTwUdYASjn
=RjRK
-----END PGP SIGNATURE-----
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to