MySQL /etc/my.cnf

Original 📋 CentOS Stream 9 31 lines

Works On

Viewing:
CentOS Stream 9
Same on:
Red Hat Enterprise Linux 8 (Ootpa)
Other versions:

Details

Size
31 lines
MD5
ea34d282649767d69a65a33231244e75
SHA256
1734fab49caed23761597f11d81acd181b14d5beb2e1a88090e6f42cd3c0348d
/etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# 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
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# 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
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password

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

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Copy & Paste

curl:
curl https://exampleconfig.com/api/v1/config/original/ea34d282649767d69a65a33231244e75?hint=my.cnf
wget:
wget -O my.cnf https://exampleconfig.com/api/v1/config/original/ea34d282649767d69a65a33231244e75?hint=my.cnf

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/ea34d282649767d69a65a33231244e75?hint=my.cnf' /><config><app>MySQL</app><os>CentOS Stream 9</os><location>/etc/my.cnf</location><lines>31</lines><md5>ea34d282649767d69a65a33231244e75</md5><sha256>1734fab49caed23761597f11d81acd181b14d5beb2e1a88090e6f42cd3c0348d</sha256></config></prompt>

Paste into Claude, ChatGPT, or any AI assistant.

Install MySQL

Debian

sudo apt update && sudo apt install mysql-server

Red Hat Enterprise Linux

sudo yum install mysql-server

Ubuntu

sudo apt update && sudo apt install mysql-server

File Location

File Path
/etc/my.cnf
Directory
/etc/
Significance
System-wide configuration directory
Description
Files in /etc/ contain system-wide configuration settings that affect all users.

FAQ

When should I use this my.cnf?

Use it to restore a missing default, confirm what shipped, or diff against your current MySQL config.

How do I restore MySQL defaults?

Download the file, back up the current one in /etc/my.cnf, replace it, then reload or restart MySQL.

Is my.cnf safe for production?

It is the vendor default for CentOS Stream 9. Treat it as a baseline and review security and performance settings before production use.

How does this differ from other OS versions?

Defaults vary by distro and version. This copy matches CentOS Stream 9.

Can I use this for MySQL troubleshooting?

Yes. Diff it against yours to find drift, then restore only the sections you need.