MariaDB
Set up a mariadb SQL server. It support multible database, users and permission. If you want only connect from inside use core-mariadb
as host address.
{
"databases": ["homeassistant"],
"logins": [
{
"username": "hass",
"host": "homeassistant",
"password": "securePassword"
}
],
"rights": [
{
"username": "hass",
"host": "homeassistant",
"database": "homeassistant",
"grant": "ALL PRIVILEGES ON"
}
]
}
Configuration variables:
- databases (Require): Listen of databases.
- logins (Require): Listen of logindata they will create or update.
- username (Require): Username for login.
- host (Require): Host for login, if you need a login with multibe hosts, use ‘%’.
- password (Require): Password for login.
- rights (Require): Listen of rights to be handle.
- username (Require): Username for grant rights.
- host (Require): Host is a part of username like above.
- database (Require): Database name to grant this user rights to.
- grant (Require): SQL grant part for access too.
Home Assistant configuration
Use the following configuration in Home Assistant to use the database above:
recorder:
db_url: mysql://hass:securePassword@core-mariadb/homeassistant