I have to admit that I wasn't familiar with mysql-config-editor.
But also, in a VPS controlled by Ansible deployment (you know exactly
who has access to the server -- mostly just 'you') it's helpful to be
able to quickly grab the random DB password (from /root/.my.cnf) for
GUI client setup of MySQ
>Better practice is to have a ~/.my.cnf file or elsewhere[...]
I am surprised that nobody mentioned the command "mysql_config_editor"
and mysql's --login-path option, which permit passwordless database
logins more securely than storing plaintext passwords in .my.cnf.
https://dev.mysql.com/doc
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]
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@
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
> 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]
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
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
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
