Hi, I have been running MariaDB for long time under and I was not fast enought to find out the damage so my my dayly backup last week did not help.
My setup is ubuntu running docker with hass.io
I have accept the fact to start over with a clean database but I’m getting rights issue.
I have tried to uninstall MariaDB, delete the mariadb image in docker.
What do I missing?
Here is the log.
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
[12:47:54] INFO: Ensuring internal database upgrades are performed
This installation of MariaDB is already upgraded to 10.4.12-MariaDB, use --force if you still need to run mysql_upgrade
[12:47:54] INFO: Ensure databases exists
[12:47:54] INFO: Create database homeassistant
[12:47:54] INFO: Create database tasker
[12:47:54] INFO: Ensure users exists and are updated
[12:47:54] INFO: Create user hass
[12:47:54] INFO: Init/Update rights
[12:47:54] INFO: Alter rights for hass to homeassistant,tasker
[12:47:55] INFO: Successfully send service information to Home Assistant.
2020-05-16 12:48:11 24 [Warning] Access denied for user ‘hass’@’%’ to database ‘homeassistant’
Here is my old configuration that I have reused.
databases:
- homeassistant
- tasker
logins:
- username: hass
host: '%'
password: mypassword
rights:
- username: hass
host: '%'
database: 'homeassistant,tasker'
grant: ALL PRIVILEGES ON
Thanks