Sysadmin > MySQL > ExampleMyCnf

Minimal MySQL config

Example MySQL or MariaDB configuration file (my.cnf) for FreeBSD

## SERVER ##
[mysqld]
datadir                         = /var/db/mysql
 
socket                          = /tmp/mysql.sock
pid-file                        = /var/run/mysql/mysql.pid
 
log-error                      = /var/log/mysql/mysql-error.log
log-queries-not-using-indexes  = 1
slow-query-log                 = 1
slow-query-log-file            = /var/log/mysql/mysql-slow.log

#bind-addressi=127.0.0.1
skip-networking