The best way to change MySQL root password without copying a file text

Archives Ansible Project
1

Hello guys,

I’m new at Ansible and i was playing around with it and i was setting a galera-cluster with MariaDB, everything went well, but when i tried to set mysql_secure_installation using my playbook with Ansible i had to send a copy a file (/root/my.cnf) to my node (root/.my.cnf) with my user and password on it.

I thought this approach was not very security, is there any other way to do this? I mean…it’s a fresh install and i dont have a root password yeat, i’m trying to do everything with ansible.

Any help will be appreciate!

Tks!!

2

You can keep either the file or the secrets encrypted with
ansible-vault until the time of transfer.