How do you automate Percona 5.7 deployment? (problem: random root password)


5.7 introduced a “security” feature of generating a random root password and revealing it in log, which breaks most sane automated deployment approaches.

In Debian there is preseed but in Centos there is no entry point in installation for root password change.

I can only see two approaches - one grepping the logfile hoping that the syntax will remain consistent between releases and then executing a shell script changing the root password (since the generated password is already “expired” and my favorite automation tool can’t cope with that) or the second one, fiddling with --skip-grants. Either of these approaches feel more like a hack rather than solution.

How do you automate Percona deployment in Redhat / Centos / etc…?