Get the default configuration file mariadb.cnf for MariaDB, optimized for Ubuntu 16.04 LTS (Xenial Xerus). 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.cnf.
For more configurations and setup guides, visit our related files section to further customize your system.
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
Download the raw file with wget or curl
wget -O mariadb.cnf.example https://exampleconfig.com/static/raw/mariadb/ubuntu16.04/etc/mysql/mariadb.cnf
curl https://exampleconfig.com/static/raw/mariadb/ubuntu16.04/etc/mysql/mariadb.cnf > mariadb.cnf.example
Other config files you might find useful