# Sample my.cnf — samplefiles.com
[client]
default-character-set = utf8mb4

[mysqld]
bind-address = 127.0.0.1
port = 3306
character-set-server = utf8mb4
collation-server = utf8mb4_0900_ai_ci
max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 1
log_bin = mysql-bin
binlog_expire_logs_seconds = 604800