When should I use this my.cnf?
Use it to restore a missing default, confirm what shipped, or diff against your current MySQL config.
# 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
curl https://exampleconfig.com/api/v1/config/original/ea34d282649767d69a65a33231244e75?hint=my.cnf
wget -O my.cnf https://exampleconfig.com/api/v1/config/original/ea34d282649767d69a65a33231244e75?hint=my.cnf
<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.
sudo apt update && sudo apt install mysql-server
sudo yum install mysql-server
sudo apt update && sudo apt install mysql-server
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.