Config Files · 1 file
Sample my.cnf File
my.cnf is the MySQL and MariaDB option file. Our sample is realistic and valid for its tool, with fake hosts and secrets.
my.cnf · 413 B
MySQL my.cnf
A MySQL/MariaDB option file with client and server groups, character set, InnoDB buffer sizes, slow-query logging and binary logs. All hosts, keys and secrets are fake.
CC0 · free for any use · Verified by an independent tool · Report a problem
# 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 = 604800File details
Download from the command line
curl -L -o my.cnf https://files.samplefiles.com/config/my-cnf/my.cnfwget https://files.samplefiles.com/config/my-cnf/my.cnfhttps://files.samplefiles.com/config/my-cnf/my.cnfprintf '%s %s\n' 99d5a9d9ca564d478a5a7513fa8ea05eb111350057dab763d88e658e94e0cc8e my.cnf | shasum -a 256 -cOr check the download in your browser with the checksum calculator.