[Discuss] Fwd: mysql question

[Greg Rundlett (freephile)]

---------- Forwarded message ---------
From: Greg Rundlett (freephile) <greg at freephile.com>
Date: Sat, Nov 21, 2020 at 7:00 PM
Subject: Re: [Discuss] mysql question
To: dan moylan <jdm at 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 <jdm at moylan.us> wrote:
>
>
> On Sat, Nov 21, 2020 at 9:13 AM dan moylan <jdm at 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)
> jdm at moylan.us
> www.moylan.us
> [BLM]
> _______________________________________________
> Discuss mailing list
> Discuss at lists.blu.org
> http://lists.blu.org/mailman/listinfo/discuss