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) Ubuntu 22.04 LTS (Jammy Jellyfish) Ubuntu 24.04 LTS (Noble Numbat)

Details

Size: 24 lines
MD5: 593e201008e699b8af7abcf9eb6c5d88
SHA256: 185592d3c92202bc237260a7d1ca1ed816b174fc024e0bf1cc037bad6d15429c

/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf

#
# These groups are read by MariaDB command-line tools
# Use it for options that affect only one utility
#

[mysql]
# Default is Latin1, if you need UTF-8 set this (also in server section)
default-character-set = utf8mb4

[mysql_upgrade]

[mysqladmin]

[mysqlbinlog]

[mysqlcheck]

[mysqldump]

[mysqlimport]

[mysqlshow]

[mysqlslap]

Copy & Paste

curl:

curl https://exampleconfig.com/api/v1/config/original/593e201008e699b8af7abcf9eb6c5d88?hint=50-mysql-clients.cnf

wget:

wget -O 50-mysql-clients.cnf https://exampleconfig.com/api/v1/config/original/593e201008e699b8af7abcf9eb6c5d88?hint=50-mysql-clients.cnf

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/593e201008e699b8af7abcf9eb6c5d88?hint=50-mysql-clients.cnf' /><config><app>MariaDB</app><os>Debian 9 (Stretch)</os><location>/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf</location><lines>24</lines><md5>593e201008e699b8af7abcf9eb6c5d88</md5><sha256>185592d3c92202bc237260a7d1ca1ed816b174fc024e0bf1cc037bad6d15429c</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.conf.d/50-mysql-clients.cnf

FAQ

When should I use this 50-mysql-clients.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.conf.d/50-mysql-clients.cnf, replace it, then reload or restart MariaDB.

Is 50-mysql-clients.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.conf.d/50-mysql-clients.cnf