Scripts used in the Hassbian image.
| HOME | SUITES | HASSBIAN-CONFIG (CLI) | CONTRIBUTE |
This script installs the tools needed to connect to a MS SQL database and it’s dependencies for use with the recorder component in Home Assistant. No database or database user is created during this setup and will need to be created manually.
sudo hassbian-config install mssql
No script available, maybe you could write one?
If so, add an PR here when you are done:
homeassistant/hassbian-scripts
Example for creating database:
sudo mysql -u root -p
CREATE DATABASE homeassistant;
CREATE USER 'homeassistantuser' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON homeassistant.* TO 'homeassistantuser';
FLUSH PRIVILEGES;
exit
The installation script was originally contributed by @Landrash.