Get the default configuration file 50-mysqld_safe.cnf for MariaDB, optimized for Debian GNU/Linux 9 (stretch). This example configuration ensures optimal compatibility and performance for MariaDB, making it easy to set up and adjust to meet your needs.
Find and download the configuration file here: /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf.
For more configurations and setup guides, visit our related files section to further customize your system.
# NOTE: This file is read only by the traditional SysV init script, not systemd.
# MariaDB systemd does _not_ utilize mysqld_safe nor read this file.
#
# For similar behaviour, systemd users should create the following file:
# /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
#
# To achieve the same result as the default 50-mysqld_safe.cnf, please create
# /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
# with the following contents:
#
# [Service]
# User=mysql
# StandardOutput=syslog
# StandardError=syslog
# SyslogFacility=daemon
# SyslogLevel=err
# SyslogIdentifier=mysqld
#
# For more information, please read https://mariadb.com/kb/en/mariadb/systemd/
#
[mysqld_safe]
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# especially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
socket = /var/run/mysqld/mysqld.sock
nice = 0
skip_log_error
syslog
Download the raw file with wget or curl
wget -O 50-mysqld_safe.cnf.example https://exampleconfig.com/static/raw/mariadb/debian9/etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf
curl https://exampleconfig.com/static/raw/mariadb/debian9/etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf > 50-mysqld_safe.cnf.example
Other config files you might find useful