mysql參考配置文件[root@rancher-db ~]# cat /etc/my.cnf

[client]

port? ? ? ? ? ? = 3306

socket? ? ? ? ? = /var/lib/mysql/mysql.sock

[mysqld_safe]

socket? ? ? ? ? = /var/lib/mysql/mysql.sock

nice? ? ? ? ? ? = 0

[mysqld]

user? ? ? ? ? ? = mysql

pid-file? ? ? ? = /var/run/mariadb/mariadb.pid

socket? ? ? ? ? = /var/lib/mysql/mysql.sock

port? ? ? ? ? ? = 3306

basedir? ? ? ? ?= /usr

datadir? ? ? ? ?= /var/lib/mysql

tmpdir? ? ? ? ? = /tmp

lc-messages-dir = /usr/share/mysql

skip-external-locking

key_buffer_size = 16M

max_allowed_packet? ? ? = 64M

thread_stack? ? ? ? ? ? = 192K

thread_cache_size? ? ? ?= 8

myisam-recover? ? ? ? ?= BACKUP

max_connections? ? ? ? = 1000

sql_mode = ONLY_FULL_GROUP_BY

query_cache_limit? ? ? ?= 2M

query_cache_size? ? ? ? = 32M

log_error = /var/log/mariadb/mariadb.log

expire_logs_days? ? ? ? = 2

max_binlog_size? ? ? ? ?= 100M

innodb_file_per_table = 1

innodb_buffer_pool_size = 6GB

[mysqldump]

quick

quote-names

max_allowed_packet? ? ? = 64M

[mysql]

#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]

key_buffer_size = 64M

!includedir /etc/my.cnf.d

總結

以上是生活随笔為你收集整理的rancher 外置 mysql_rancher使用外部数据库无法正常使用的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。