-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mike --
...and then Michael Stassen said... % % Mikael Fridh wrote: [And thank you to Mikael, too.] % % >On Wednesday 12 November 2003 17.15, David T-G wrote: % > % >>What if one user connects to the database as different users (as I do, in ... % > % >set up different my.cnf files for your different scripted users. % >Make sure that they have proper permissions % >then call mysql from your scripts like this: % >mysql --defaults-file=/home/blah/secret/stupid-user.my.cnf % >mysql --defaults-file=/home/blah/secret/clever-user.my.cnf Ahhhh... % > % >more info from "mysql --help" OK. % % Right. Note that the --defaults-file= option does not just specify an % alternate .my.cnf, it also prevents looking in the global configuration % files /etc/my.cnf and mysql_data_dir/my.cnf Right. % (/usr/local/mysql/data/my.cnf, for example). So, if you have anything % set in one of the global files which you need, you'll have to duplicate % those settings in your local files. Right. Kind of a bummer. % % Alternatively, you can use the --defaults-extra-file= option. This % reads the named file in between the global files and .my.cnf. Last % mention of a setting wins, so you would not put a password in .my.cnf in % this case. Aha! Most excellent. Yes, I think that that would be a good plus safe way to go. Then one need only make sure that mysql is in the path under cron :-) % % Wouldn't it be nice if these options were mentioned in the mysql man % page? Or is it just me? Well, it could be, but if it's there I missed it, too! Thanks again & HAND :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE/sooCGb7uCXufRwARAiPsAJ0aMingtyWkmjwTehyBohOGJ19/BACdFW/x wkUhMt+ALUtMM060bUnxvM4= =QcY8 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]