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
