[Discuss] mysql question

[dan moylan]

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]