When should I use this mysql.cnf?
Use it to restore a missing default, confirm what shipped, or diff against your current MySQL config.
MySQL /etc/mysql/mysql.cnf
Original
๐ Debian 9 (Stretch)
33 lines
Works On
Viewing:
Debian 9 (Stretch)
Same on:
Other versions:
Details
- Size
- 33 lines
- MD5
- 53ae2664855ebc0842cc85c90a995cec
- SHA256
- 1795e83b09cbec984caca2187642ab98a5dd78f57ec4a0268c4a0487749fe9c0
/etc/mysql/mysql.cnf
# Copyright (c) 2015, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License, version 2.0, # as published by the Free Software Foundation. # # This program is also distributed with certain software (including # but not limited to OpenSSL) that is licensed under separate terms, # as designated in a particular file or component or in included license # documentation. The authors of MySQL hereby grant you an additional # permission to link the program and your derivative works with the # separately licensed software that they have included with MySQL. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License, version 2.0, for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA # # The MySQL Server configuration file. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/
Copy & Paste
curl:
curl https://exampleconfig.com/api/v1/config/original/53ae2664855ebc0842cc85c90a995cec?hint=mysql.cnf
wget:
wget -O mysql.cnf https://exampleconfig.com/api/v1/config/original/53ae2664855ebc0842cc85c90a995cec?hint=mysql.cnf
For AI Agents
<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/53ae2664855ebc0842cc85c90a995cec?hint=mysql.cnf' /><config><app>MySQL</app><os>Debian 9 (Stretch)</os><location>/etc/mysql/mysql.cnf</location><lines>33</lines><md5>53ae2664855ebc0842cc85c90a995cec</md5><sha256>1795e83b09cbec984caca2187642ab98a5dd78f57ec4a0268c4a0487749fe9c0</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
FAQ
How do I restore MySQL defaults?
Download the file, back up the current one in /etc/mysql/mysql.cnf, replace it, then reload or restart MySQL.
Is mysql.cnf safe for production?
It is the vendor default for Debian 9 (Stretch). 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 Debian 9 (Stretch).
Can I use this for MySQL troubleshooting?
Yes. Diff it against yours to find drift, then restore only the sections you need.
