Request: Write mysql root credentials to /root/.my.cnf when imaging.

[patch0]

(Note: This may be something for imager, or Stretch, but applied to Symbiosis images only)

It's never clear that the root, admin and mysql root@localhost users all have the same password in a newly imaged machine, which leads to users likely changing the root/admin passwords like they should, and not making note of the root@localhost password we set for mysql.

Simply writing the below to /root/.my.cnf (with relevant permissions) would make password recovery simpler, and allow the user to log in directly.

[client]
user=root
password="<example>"

There's a small outside risk to this, by keeping it in /root would negate most of this, and make things simpler for users.

Originally reported on Bytemark's Gitlab by @pcammish on 2017-04-13T13:49:00.308Z

[patch0]

I'm not sure this is a good idea without keeping it up to date when the root password changes inside mysql.

I think the debian.cnf is enough to reset a forgotten root password.

Documenting the procedure for resetting a root password for mysql would be sufficient I think.

Originally posted by @patch0 on 2017-04-20T13:26:28.583Z