I tried to follow the steps mentioned in mysql charm:

$ juju ssh <unit> mysql -u root -p
enter root password:


But after installing mysql charm, /var/lib/juju/mysql.passwd file was not there. Kindly help locating mysql root password.


It appears that the mysql.passwd file was moved to /var/lib/mysql/mysql.passwd but the README was not updated. I've submitted a patch to the charm to update the README. However, you should be able to juju ssh mysql/0 and cat /var/lib/mysql/mysql.passwd to get the current MySQL root password.

|improve this answer|||||
  • any idea on the current charm..? I dont find any mysql folder in the lib directory .. – Mohan Sanagapalli Aug 30 '17 at 2:10

From the juju controller run the following command to get all mysql passwords

juju run --unit mysql/0 leader-get
|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.