Date: Thu, 09 Oct 2008 08:46:05 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: Zbigniew Szalbot <zszalbot@gmail.com> Cc: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: mysql binlogs and their expiry times Message-ID: <48EDB6BD.1070209@infracaninophile.co.uk> In-Reply-To: <94136a2c0810082206u3e1de52el320672c67665ef5a@mail.gmail.com> References: <94136a2c0810072248t7143c6am7b5740a7d770317d@mail.gmail.com> <48ED0986.6060100@infracaninophile.co.uk> <94136a2c0810082206u3e1de52el320672c67665ef5a@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48EDB6BD.1070209>