HomeAssistant MariaDB Password changed after package upgrade?

Discuss Apps
1

My HomeAssistant stopped working. I checked the log file at “/var/log/homeassistant/homeassistant.log” and found this:

sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1045, "Access denied for user 'homeassistant'@'localhost' (using password: YES)")

This indicates the “homeassistant” user in MariaDB can’t authenticate successfully.

To fix this, I found the password it wanted to use in the “/home/yunohost.app/homeassistant/configuration.yaml” file, at the recorder.db_url property.

Then I open the MySQL client with mysql -u root -p, then:
USE mysql;
SET PASSWORD FOR 'homeassistant'@'localhost' = PASSWORD('the_password');

Hope this helps someone else.