Get the default configuration file 50-mysql-clients.cnf for MariaDB, optimized for Ubuntu 16.04 LTS (Xenial Xerus). 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-mysql-clients.cnf.
For more configurations and setup guides, visit our related files section to further customize your system.
#
# 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]
Download the raw file with wget or curl
wget -O 50-mysql-clients.cnf.example https://exampleconfig.com/static/raw/mariadb/ubuntu16.04/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf
curl https://exampleconfig.com/static/raw/mariadb/ubuntu16.04/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf > 50-mysql-clients.cnf.example
Other config files you might find useful