---------- Forwarded message --------- From: Greg Rundlett (freephile) <g...@freephile.com> Date: Sat, Nov 21, 2020 at 7:00 PM Subject: Re: [Discuss] mysql question To: dan moylan <j...@moylan.us>
The -p option is forcing the prompt. When using your config, don't use the -p (password) option. Greg Rundlett https://eQuality-Tech.com https://freephile.org On Sat, Nov 21, 2020 at 5:34 PM dan moylan <j...@moylan.us> wrote: > > > On Sat, Nov 21, 2020 at 9:13 AM dan moylan <j...@moylan.us> wrote: > > > mysqldump -u moylanus_moy -p'********' -l moylanus_dat > moylanus_dat.sql > > > the script runs fine on my local computer, but on the remote > > one i get a warning that the password on the command line is > > insecure -- access denied. is there some way around this? > > > bill ricker writes: > > That is correct, it is insecure. On a server, commandlines are visible > > between users. > > > Better practice is to have a ~/.my.conf file or elsewhere - you can use a > > commandline variable to redirect > > > https://stackoverflow.com/questions/16299603/mysql-utilities-my-cnf-option-file > > ok -- i created ~/my.cnf as follows: > > [mysql] > user=moylanus_moy > password="*******" > > [mysqldump] > user=moylanus_moy > password="*******" > > i then tried: > > mysqldump -u moylanus_moy -p -l moylanus_dat > moylanus_dat.sql > > and it still asks for a password. what have i missed? > > tia, > ole dan > > j. daniel moylan > 84 harvard ave > brookline, ma 02446-6202 > 617-777-0207 (cel) > j...@moylan.us > www.moylan.us > [BLM] > _______________________________________________ > Discuss mailing list > Discuss@lists.blu.org > http://lists.blu.org/mailman/listinfo/discuss _______________________________________________ Discuss mailing list Discuss@lists.blu.org http://lists.blu.org/mailman/listinfo/discuss
