Title here
Summary here
MySQL
Version support
See the MySQL Database Integration reference guide for supported version information.
Configuration
This section is intended as an example configuration to help users with a rough contextual layout of this configuration section, it is not intended to explain the options.
The configuration shown may not be a valid configuration, and you should see the options section below and the navigation links to properly understand each option individually.
storage:
encryption_key: 'a_very_important_secret'
mysql:
address: 'tcp://127.0.0.1:3306'
database: 'authelia'
username: 'authelia'
password: 'mypassword'
timeout: '5s'
tls:
server_name: 'mysql.example.com'
skip_verify: false
minimum_version: 'TLS1.2'
maximum_version: 'TLS1.3'
certificate_chain: |
-----BEGIN CERTIFICATE-----
...
-----END CERTIFICATE-----
-----BEGIN CERTIFICATE-----
...
-----END CERTIFICATE-----
private_key: |
-----BEGIN RSA PRIVATE KEY-----
...
-----END RSA PRIVATE KEY----- Options
This section describes the individual configuration options.
encryption_key
See the encryption_key docs.
address
Reference Note: This configuration option uses a common syntax. For more information please see both the configuration example and the Common Syntax: Address reference guide.
Configures the address for the MySQL/MariaDB Server. The address itself is a connector and the scheme must either be
the unix scheme or one of the tcp schemes.
Examples:
storage:
mysql:
address: 'tcp://127.0.0.1:3306'storage:
mysql:
address: 'tcp://[fd00:1111:2222:3333::1]:3306'storage:
mysql:
address: 'unix:///var/run/mysqld.sock'database
string
required
The database name on the database server that the assigned user has access to for the purpose of Authelia.
username
string
required
The username paired with the password used to connect to the database.
password
string
required
Important Note: This can also be defined using a secret which is strongly recommended especially for containerized deployments.
The password paired with the username used to connect to the database.
It’s strongly recommended this is a Random Alphanumeric String with 64 or more characters and the user password is changed to this value.
timeout
Reference Note: This configuration option uses a common syntax. For more information please see both the configuration example and the Common Syntax: Duration reference guide.
The SQL connection timeout.
tls
Reference Note: This configuration option uses a common structure. For more information please see both the configuration example and the Common Structure: TLS reference guide.
If defined enables connecting to MySQL or MariaDB over a TLS socket, and additionally controls the TLS connection validation parameters.
Prev
SQLite3
Next
Notifications