MariaDB /etc/mysql/my.cnf.fallback

原始 📋 Debian 13 (Trixie) 23 行

详情

大小
23 行
MD5
cfe2bc1819d5e200eca8ca6912f714af
SHA256
b562ddb4d6f452725287c4842d9ad36052bf1a1cc1f4abef51ba55edbf3ed5d6
/etc/mysql/my.cnf.fallback
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

!includedir /etc/mysql/conf.d/

复制粘贴

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

给 AI Agent 用

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/cfe2bc1819d5e200eca8ca6912f714af?hint=my.cnf.fallback' /><config><app>MariaDB</app><os>Debian 13 (Trixie)</os><location>/etc/mysql/my.cnf.fallback</location><lines>23</lines><md5>cfe2bc1819d5e200eca8ca6912f714af</md5><sha256>b562ddb4d6f452725287c4842d9ad36052bf1a1cc1f4abef51ba55edbf3ed5d6</sha256></config></prompt>

粘贴到 Claude、ChatGPT 或任何 AI 助手里。

安装 MariaDB

Alpine Linux

sudo apk add mariadb

Debian

sudo apt update && sudo apt install mariadb-server

Red Hat Enterprise Linux

sudo yum install mariadb-server

Ubuntu

sudo apt update && sudo apt install mariadb-server

文件位置

文件路径
/etc/mysql/my.cnf.fallback
目录
/etc/mysql/
用途
系统级配置目录
说明
/etc/ 里的文件是系统级配置,影响所有用户。

FAQ

什么时候该用这个 my.cnf.fallback?

用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。

怎么恢复 MariaDB 的默认配置?

下载文件,把 /etc/mysql/my.cnf.fallback 里的当前配置备份好,替换掉,然后 reload 或 restart MariaDB。

my.cnf.fallback 适合直接上生产吗?

这是 Debian 13 (Trixie) 的厂商默认配置,只能当基线。上生产前请检查安全和性能设置。

和其他 OS 版本有什么不同?

默认值会随发行版和版本变化,这份对应 Debian 13 (Trixie)。

我可以用它来排查 MariaDB 吗?

可以。和你的配置做 diff 找出漂移,然后只恢复需要的段落。