Works On

Viewing:

Debian 9 (Stretch)

Same on:

Debian 10 (Buster) Ubuntu 18.04 LTS (Bionic Beaver) Ubuntu 20.04 LTS (Focal Fossa)

Other versions:

Debian 11 (Bullseye) Debian 12 (Bookworm) Debian 13 (Trixie) Ubuntu 22.04 LTS (Jammy Jellyfish) Ubuntu 24.04 LTS (Noble Numbat)

Details

Size: 23 lines
MD5: 46a0151b3b022b225cabb97e6d1ad947
SHA256: 9ea2014b6a0b2db53352c64b3d6a569ad8bf613e719b84ccc11ff84a37e035af

/etc/mysql/mariadb.cnf

# 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/

Copy & Paste

curl:

curl https://exampleconfig.com/api/v1/config/original/46a0151b3b022b225cabb97e6d1ad947?hint=mariadb.cnf

wget:

wget -O mariadb.cnf https://exampleconfig.com/api/v1/config/original/46a0151b3b022b225cabb97e6d1ad947?hint=mariadb.cnf

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/46a0151b3b022b225cabb97e6d1ad947?hint=mariadb.cnf' /><config><app>MariaDB</app><os>Debian 9 (Stretch)</os><location>/etc/mysql/mariadb.cnf</location><lines>23</lines><md5>46a0151b3b022b225cabb97e6d1ad947</md5><sha256>9ea2014b6a0b2db53352c64b3d6a569ad8bf613e719b84ccc11ff84a37e035af</sha256></config></prompt>

Paste into Claude, ChatGPT, or any AI assistant.

Install MariaDB

Alpine Linux

sudo apk add mariadb

Debian

sudo apt update && sudo apt install mariadb-server

Red Hat Enterprise Linux

sudo yum install mariadb-server

Ubuntu

sudo apt update && sudo apt install mariadb-server

File Location

File Path

/etc/mysql/mariadb.cnf

FAQ

When should I use this mariadb.cnf?

Use it to restore a missing default, confirm what shipped, or diff against your current MariaDB config.

How do I restore MariaDB defaults?

Download the file, back up the current one in /etc/mysql/mariadb.cnf, replace it, then reload or restart MariaDB.

Is mariadb.cnf safe for production?

It is the vendor default for Debian 9 (Stretch). Treat it as a baseline and review security and performance settings before production use.

How does this differ from other OS versions?

Defaults vary by distro and version. This copy matches Debian 9 (Stretch).

Can I use this for MariaDB troubleshooting?

Yes. Diff it against yours to find drift, then restore only the sections you need.

MariaDB /etc/mysql/mariadb.cnf