MariaDB /etc/mysql/mariadb.cnf

Original 📋 Ubuntu 22.04 LTS (Jammy Jellyfish) 29 lines

Works On

Viewing:
Ubuntu 22.04 LTS (Jammy Jellyfish)
Same on:
Debian 11 (Bullseye) Debian 12 (Bookworm) Debian 13 (Trixie) Ubuntu 24.04 LTS (Noble Numbat)
Other versions:

Details

Size
29 lines
MD5
f78499dd07dccc3238cc15dd937b87bb
SHA256
65084b5344fcbae09425c648a9bfb1ff99c1fd0d83f1eff5bc08bf8032de8981
/etc/mysql/mariadb.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 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.
#
# If you are new to MariaDB, check out https://mariadb.com/kb/en/basic-mariadb-articles/

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock

# 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/f78499dd07dccc3238cc15dd937b87bb?hint=mariadb.cnf
wget:
wget -O mariadb.cnf https://exampleconfig.com/api/v1/config/original/f78499dd07dccc3238cc15dd937b87bb?hint=mariadb.cnf

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/f78499dd07dccc3238cc15dd937b87bb?hint=mariadb.cnf' /><config><app>MariaDB</app><os>Ubuntu 22.04 LTS (Jammy Jellyfish)</os><location>/etc/mysql/mariadb.cnf</location><lines>29</lines><md5>f78499dd07dccc3238cc15dd937b87bb</md5><sha256>65084b5344fcbae09425c648a9bfb1ff99c1fd0d83f1eff5bc08bf8032de8981</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
Directory
/etc/mysql/
Significance
System-wide configuration directory
Description
Files in /etc/ contain system-wide configuration settings that affect all users.

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 Ubuntu 22.04 LTS (Jammy Jellyfish). 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 Ubuntu 22.04 LTS (Jammy Jellyfish).

Can I use this for MariaDB troubleshooting?

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