[Discuss] mysql question

[Bill Ricker]

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?
>

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