Comment 5 for bug 1423153

Oh, bother that's a problem.

On Wed Feb 18 2015 at 10:20:47 AM Jacek Nykis <email address hidden>
wrote:

> Also see related LP1423187
>
> --
> You received this bug notification because you are subscribed to mysql
> in Juju Charms Collection.
> Matching subscriptions: MySQL-Charm
> https://bugs.launchpad.net/bugs/1423153
>
> Title:
> /var/lib/mysql/mysql.passwd no longer exist
>
> Status in mysql package in Juju Charms Collection:
> New
>
> Bug description:
> The mysql charm changed the way root password is stored without
> providing backwards compatibility.
> Up until recently we always had root password available in
> /var/lib/mysql/mysql.passwd file, now it seems to be in the peer relation.
>
> I am pretty sure this problem was introduced in revision 137
>
> There are 2 problems with this change
> 1. Many scripts, wiki pages and users (myself included) depended on
> /var/lib/mysql/mysql.passwd. Removing it without notice causes confusion
> 2. With peer relation there is no easy way to retrieve the password from
> the unit itself. One use case is a sysadmin who needs to check database
> structure. It used to be possible to run " mysql -uroot -p`cat
> /var/lib/mysql/mysql.passwd`". Now the password can be retrieved using
> multiple juju run commands or by setting up environment on the unit and
> running relation-get but none of this methods are trivial
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/charms/+source/mysql/+bug/
> 1423153/+subscriptions
>