mysql binlogs and their expiry times

[Matthew Seaman]

-----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-----