什么时候该用这个 50-client.cnf?
用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。
# # This group is read by the client library # Use it for options that affect all clients, but not the server # [client] # Default is Latin1, if you need UTF-8 set this (also in server section) default-character-set = utf8mb4 # socket location socket = /var/run/mysqld/mysqld.sock # Example of client certificate usage # ssl-cert=/etc/mysql/client-cert.pem # ssl-key=/etc/mysql/client-key.pem # # Allow only TLS encrypted connections # ssl-verify-server-cert=on # This group is *never* read by mysql client library, though this # /etc/mysql/mariadb.cnf.d/client.cnf file is not read by Oracle MySQL # client anyway. # If you use the same .cnf file for MySQL and MariaDB, # use it for MariaDB-only client options [client-mariadb]
curl https://exampleconfig.com/api/v1/config/original/f2016c3fdd7e68e49673dc87749ba004?hint=50-client.cnf
wget -O 50-client.cnf https://exampleconfig.com/api/v1/config/original/f2016c3fdd7e68e49673dc87749ba004?hint=50-client.cnf
<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/f2016c3fdd7e68e49673dc87749ba004?hint=50-client.cnf' /><config><app>MariaDB</app><os>Ubuntu 20.04 LTS (Focal Fossa)</os><location>/etc/mysql/mariadb.conf.d/50-client.cnf</location><lines>25</lines><md5>f2016c3fdd7e68e49673dc87749ba004</md5><sha256>0fa83873cbe486c226c1ce4dfdcf07fc7f5360e8cfa57667921146ce1ee62e3f</sha256></config></prompt>
粘贴到 Claude、ChatGPT 或任何 AI 助手里。
sudo apk add mariadb
sudo apt update && sudo apt install mariadb-server
sudo yum install mariadb-server
sudo apt update && sudo apt install mariadb-server
什么时候该用这个 50-client.cnf?
用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。
怎么恢复 MariaDB 的默认配置?
下载文件,把 /etc/mysql/mariadb.conf.d/50-client.cnf 里的当前配置备份好,替换掉,然后 reload 或 restart MariaDB。
50-client.cnf 适合直接上生产吗?
这是 Ubuntu 20.04 LTS (Focal Fossa) 的厂商默认配置,只能当基线。上生产前请检查安全和性能设置。
和其他 OS 版本有什么不同?
默认值会随发行版和版本变化,这份对应 Ubuntu 20.04 LTS (Focal Fossa)。
我可以用它来排查 MariaDB 吗?
可以。和你的配置做 diff 找出漂移,然后只恢复需要的段落。