Debian 12 (Bookworm) 默认配置

#!/bin/bash # # This script is executed by both SysV init /etc/init.d/mariadb and # systemd mariadb.service o…

#!/bin/bash
#
# This script is executed by both SysV init /etc/init.d/mariadb and
# systemd mariadb.service on every (re)start.
#
# Changes to this file will be preserved when updating the Debian pac…

# The MariaDB configuration file # # The MariaDB/MySQL tools read configuration files in the following order:…

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 1. "/e…

# Copyright (c) 2015, 2025, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2025, 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,…

[server] plugin_load_add=provider_snappy provider_snappy=force_plus_permanent

[server]
plugin_load_add=provider_snappy
provider_snappy=force_plus_permanent

[server] plugin_load_add=provider_lzo provider_lzo=force_plus_permanent

[server]
plugin_load_add=provider_lzo
provider_lzo=force_plus_permanent

[server] plugin_load_add=provider_lzma provider_lzma=force_plus_permanent

[server]
plugin_load_add=provider_lzma
provider_lzma=force_plus_permanent

[server] plugin_load_add=provider_lz4 provider_lz4=force_plus_permanent

[server]
plugin_load_add=provider_lz4
provider_lz4=force_plus_permanent

[server] plugin_load_add=provider_bzip2 provider_bzip2=force_plus_permanent

[server]
plugin_load_add=provider_bzip2
provider_bzip2=force_plus_permanent

# # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) shou…

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see

# this is read by the standalone daemon and embedded servers
[server]

# this is o…

# NOTE: THIS FILE IS READ ONLY BY THE TRADITIONAL SYSV INIT SCRIPT, NOT SYSTEMD. # MARIADB SYSTEMD DOES _NOT_…

# NOTE: THIS FILE IS READ ONLY BY THE TRADITIONAL SYSV INIT SCRIPT, NOT SYSTEMD.
# MARIADB SYSTEMD DOES _NOT_ UTILIZE MYSQLD_SAFE NOR READ THIS FILE.
#
# For similar behavior, systemd users should cr…

# # * Galera-related settings # # See the examples of server wsrep.cnf files in /usr/share/mysql # and read m…

#
# * Galera-related settings
#
# See the examples of server wsrep.cnf files in /usr/share/mysql
# and read more at https://mariadb.com/kb/en/galera-cluster/

[galera]
# Mandatory settings
#wsrep_on …

# # These groups are read by MariaDB command-line tools # Use it for options that affect only one utility # …

#
# These groups are read by MariaDB command-line tools
# Use it for options that affect only one utility
#

[mysql]

[mysql_upgrade]

[mysqladmin]

[mysqlbinlog]

[mysqlcheck]

[mysqldump]

[mysqlim…

# # This group is read by the client library # Use it for options that affect all clients, but not the server…

#
# This group is read by the client library
# Use it for options that affect all clients, but not the server
#

[client]
# Example of client certificate usage
#ssl-cert = /etc/mysql/client-cert.pem
…

# Copyright (c) 2015, 2025, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2025, 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,…

# # OpenSSL example configuration file. # See doc/man5/config.pod for more info. # # This is mostly being use…

#
# OpenSSL example configuration file.
# See doc/man5/config.pod for more info.
#
# This is mostly being used for generation of certificate requests,
# but may be used for auto loading of providers
…

ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAILXqpAqpBngJfoJauR85dP/N9NeLJ+TluFieOFRuwL80 root@76ca6578441c

ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAILXqpAqpBngJfoJauR85dP/N9NeLJ+TluFieOFRuwL80 root@76ca6578441c

-----BEGIN OPENSSH PRIVATE KEY----- b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAMwAAAAtzc2gtZW Qy…

-----BEGIN OPENSSH PRIVATE KEY-----
b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAMwAAAAtzc2gtZW
QyNTUxOQAAACC16qQKqQZ4CX6CWrkfOXT/zfTXiyfk5bhYnjhUbsC/NAAAAJj2c4Yn9nOG
JwAAAAtzc2gtZWQyNTUxO…

ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBLh9GF3hY8JYh8Ty1xT17+9GxpL4gOFWckiM+…

ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBLh9GF3hY8JYh8Ty1xT17+9GxpL4gOFWckiM+6zI5amSNFBhqcTJHBMwf/krnd9T01eFyPxtP+z0zhxNVgrGfck= root@76ca6578441c

-----BEGIN OPENSSH PRIVATE KEY----- b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAaAAAABNlY2RzYS 1z…

-----BEGIN OPENSSH PRIVATE KEY-----
b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAaAAAABNlY2RzYS
1zaGEyLW5pc3RwMjU2AAAACG5pc3RwMjU2AAAAQQS4fRhd4WPCWIfE8tcU9e/vRsaS+IDh
VnJIjPusyOWpkjRQYanEy…

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQCoSFZUSsUsrvn55dFcUe0ZxUZpYIMYD5+lPe487DhIM03ReySIiDAyW9Z2hNFPoDUcArxzf…

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQCoSFZUSsUsrvn55dFcUe0ZxUZpYIMYD5+lPe487DhIM03ReySIiDAyW9Z2hNFPoDUcArxzfdDtFGiKMnnCOl+oP3CMYXZ4Qg7+IxZb8Os5cH+c1RMRAN9s1MZuqiDmK29Hu9BtyQYAN+DVq/A4ZuLZQW44tSrqRws…