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 <dbarr...@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 > dbarr...@blazemonger.com > _______________________________________________ > Discuss mailing list > Discuss@lists.blu.org > http://lists.blu.org/mailman/listinfo/discuss _______________________________________________ Discuss mailing list Discuss@lists.blu.org http://lists.blu.org/mailman/listinfo/discuss
