[Discuss] mysql question

[Greg Rundlett (freephile)]

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 MySQL Workbench.

Greg Rundlett
https://eQuality-Tech.com
https://freephile.org

On Sun, Nov 22, 2020 at 12:12 PM Daniel Barrett
<dbarrett at blazemonger.com> wrote:
>
>
> >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/refman/8.0/en/mysql-config-editor.html
>
> Why do people still use .my.cnf?
>
> --
> Dan Barrett
> dbarrett at blazemonger.com
> _______________________________________________
> Discuss mailing list
> Discuss at lists.blu.org
> http://lists.blu.org/mailman/listinfo/discuss