1aca7b08cf
* e.g. to e.g., and proper case for Home Assistant * Instructions how to -> Instructions on how to
1.6 KiB
1.6 KiB
| layout | title | description | date | sidebar | comments | sharing | footer |
|---|---|---|---|---|---|---|---|
| page | MariaDB | MariaDB Server is one of the most popular database servers in the world. | 2017-04-30 13:28 | true | false | true | true |
Set up a mariadb SQL server. It supports multiple databases, users, and permission settings. If you want to only connect from inside Home Assistant use core-mariadb as the 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): List of databases.
- logins (Require): List of SQL accounts to create or update.
- username (Require): Username for account.
- host (Require): Host for account. If you need an account on multiple hosts, use '%'.
- password (Require): Password for account.
- rights (Require): List of rights to be granted.
- username (Require): Username for granted rights.
- host (Require): Host is a part of username like above.
- database (Require): Database name on which to grant user rights.
- grant (Require): SQL grant part for access too.
{% linkable_title Home Assistant configuration %}
Use the following configuration in Home Assistant to use the database above:
recorder:
db_url: mysql://hass:securePassword@core-mariadb/homeassistant