# The following options will be passed to all MariaDB clients

[client]

# Please note that storing the password in this file is not safe. For this

# purpose you can, for example, list your password in the [client] section

# of the '~/.my.cnf' configuration file with an access mode set to 400 or 600.

# password   = your_password

# port       = 3306

# socket     = /run/mysql/mysql.sock

​

# The MariaDB server

[mysqld]

​

# For security reasons, bind to 127.0.0.1 by default to enable networking

# only on the loopback interface.

bind-address    = 127.0.0.1

​

# If log-error is not set, mysqld will write to "/var/lib/mysql/$HOSTNAME.err"

# which is not beneficial for rotating the log file if it grows in size.

log-error       = /var/log/mysql/mysqld.log

​

# Operations 'LOAD DATA', 'SELECT ... INTO' and 'LOAD FILE()' will only

# work with files in the specified directory

secure_file_priv = /var/lib/mysql-files

​

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

​

# Using newer file format that supports dynamic and compressed row formats.

# If you are using replication you have to make sure, that these options are

# set everywhere the same way (probably comment them out is the easiest way)

innodb_file_format=Barracuda

innodb_file_per_table=ON

​

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin=mysql-bin

# binlog_format=mixed

​

# Remove leading # if you want to store your database elsewhere

# datadir   = /var/lib/mysql

​

# required unique id between 1 and 2^32 - 1

# defaults to 1 if master-host is not set

# but will not function as a master if omitted

server-id   = 1

​

# These are commonly set, remove the # and set as required.

# port = 3306

# socket = /run/mysql/mysql.sock

​

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M 

​

# Configure the MariaDB server to use SSL 

# ssl-ca=/etc/mysql/ssl/ca-cert.pem

# ssl-cert=/etc/mysql/ssl/server-cert.pem

# ssl-key=/etc/mysql/ssl/server-key.pem

​

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

​

[mysqld_multi]

mysqld     = /usr/bin/mysqld_safe

mysqladmin = /usr/bin/mysqladmin

log        = /var/log/mysqld_multi.log

​

# If you want to use mysqld_multi uncomment 1 or more mysqld sections

# below or add your own ones.

​

# WARNING

# --------

# If you uncomment mysqld1 than make absolutely sure, that database mysql,

# configured above, is not started.  This may result in corrupted data!

#

# [mysqld1]

# port       = 3306

# datadir    = /var/lib/mysql

# pid-file   = /var/lib/mysql/mysqld.pid

# socket     = /var/lib/mysql/mysql.sock

# user       = mysql

​

# [mysqld2]

# port       = 3307

# datadir    = /var/lib/mysql-databases/mysqld2

# pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid

# socket     = /var/lib/mysql-databases/mysqld2/mysql.sock

# user       = mysql

​

# [mysqld3]

# port       = 3308

# datadir    = /var/lib/mysql-databases/mysqld3

# pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid

# socket     = /var/lib/mysql-databases/mysqld3/mysql.sock

# user       = mysql

​

# [mysqld6]

# port       = 3309

# datadir    = /var/lib/mysql-databases/mysqld6

# pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid

# socket     = /var/lib/mysql-databases/mysqld6/mysql.sock

# user       = mysql

​

!includedir /etc/my.cnf.d

​

​