Get the default configuration file 50-client.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-client.cnf.
For more configurations and setup guides, visit our related files section to further customize your system.
#
# This group is read by the client library
# Use it for options that affect all clients, but not the server
#
[client]
# Default is Latin1, if you need UTF-8 set this (also in server section)
default-character-set = utf8mb4
# Example of client certificate usage
# ssl-cert=/etc/mysql/client-cert.pem
# ssl-key=/etc/mysql/client-key.pem
#
# Allow only TLS encrypted connections
# ssl-verify-server-cert=on
# This group is *never* read by mysql client library, though this
# /etc/mysql/mariadb.cnf.d/client.cnf file is not read by Oracle MySQL
# client anyway.
# If you use the same .cnf file for MySQL and MariaDB,
# use it for MariaDB-only client options
[client-mariadb]
Download the raw file with wget or curl
wget -O 50-client.cnf.example https://exampleconfig.com/static/raw/mariadb/debian9/etc/mysql/mariadb.conf.d/50-client.cnf
curl https://exampleconfig.com/static/raw/mariadb/debian9/etc/mysql/mariadb.conf.d/50-client.cnf > 50-client.cnf.example
Other config files you might find useful