Question

4

Not able to find juju charm mysql root password?

rated 0 times [ 4] [ 0] / answers: 1 / hits: 2708 / 2 Years ago, wed, september 7, 2022, 6:27:38

I tried to follow the steps mentioned in mysql charm:

$ juju ssh <unit> mysql -u root -p

enter root password:

/var/lib/juju/mysql.passwd

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

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

oatglori

Add To Favorites

Follow

Total Points: 313

Total Questions: 102

Total Answers: 111

Location: Guam

Member since Thu, May 18, 2023

1 Year ago

answered 2 Years ago icielight · Accepted Answer

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.