Re: [Discuss] mysql question

2020-11-21 Thread dan moylan
Greg Rundlett writes: > The -p option is forcing the prompt. When using your config, > don't use the -p (password) option. violla! many thanks -- to all. ole dan j. daniel moylan 84 harvard ave brookline, ma 02446-6202 617-777-0207 (cel) j...@moylan.us www.moylan.us [BLM]

Re: [Discuss] mysql question

2020-11-21 Thread Bill Ricker
added those -- same old, same old. i must have missed or > misunderstood something. > See Greg's mesasge. You may need to add teh commandline option to name your .cnf file; and you .cnf file must be chmod 700 of course ___ Discuss mailing list Discuss@

Re: [Discuss] mysql question

2020-11-21 Thread dan moylan
bill ricker writes: >> ok -- i created ~/my.cnf as follows: >> [mysql] >> user=moylanus_moy >> password="***" >> >> [mysqldump] >> user=moylanus_moy >> password="***" > [client] and [server] are the useful sections AFAIK. Try those instead of > [mysql] and [mysqldump] added

[Discuss] Fwd: mysql question

2020-11-21 Thread Greg Rundlett (freephile)
-- Forwarded message - From: Greg Rundlett (freephile) Date: Sat, Nov 21, 2020 at 7:00 PM Subject: Re: [Discuss] mysql question To: dan moylan The -p option is forcing the prompt. When using your config, don't use the -p (password) option. Greg Rundlett https://eQuality-Tech.co

Re: [Discuss] mysql question

2020-11-21 Thread Bill Ricker
> ok -- i created ~/my.cnf as follows: > > [mysql] > user=moylanus_moy > password="***" > > [mysqldump] > user=moylanus_moy > password="***" > > [client] and [server] are the useful sections AFAIK. Try those instead of [mysql] and [mysqldump]

Re: [Discuss] mysql question

2020-11-21 Thread dan moylan
On Sat, Nov 21, 2020 at 9:13 AM dan moylan 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

Re: [Discuss] mysql question

2020-11-21 Thread Bill Ricker
On Sat, Nov 21, 2020 at 9:13 AM dan moylan 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 w

[Discuss] mysql question

2020-11-21 Thread dan moylan
needing to dump on a regular basis a data base on a computer owned by my hosting service, i generated a bash script: 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 th