Get the default configuration file 50-client.cnf for MariaDB, optimized for Ubuntu 20.04 LTS (Focal Fossa). 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
# socket location
socket = /var/run/mysqld/mysqld.sock
# 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/ubuntu20.04/etc/mysql/mariadb.conf.d/50-client.cnf
curl https://exampleconfig.com/static/raw/mariadb/ubuntu20.04/etc/mysql/mariadb.conf.d/50-client.cnf > 50-client.cnf.example
Other config files you might find useful