HUB
Sign inSign up
mysql logo

devzyj/mysql

By devzyj

•Updated about 5 years ago

基于官方 mysql 修改了配置

Image
0

250

devzyj/mysql repository overview

基于 官方 mysql⁠ 修改了配置

  • /etc/mysql/conf.d/mysql.cnf
[mysql]

# Sets the default character set
default-character-set=utf8mb4

  • /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
datadir		= /var/lib/mysql
log-error	= /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address	= 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Set the time zone for writing logs
log_timestamps=SYSTEM

# Sets the default character set
init_connect='SET collation_connection = utf8mb4_general_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci

# Default storage engine
default-storage-engine=INNODB

# Innodb independent table space
innodb-file-per-table=ON

# Slow Query logs
slow-query-log=1
slow-query-log-file=/var/log/mysql/mysql-slow.log
long-query-time=3

# Query log
#general-log=1
#general-log-file=/var/log/mysql/mysql.log

Tag summary

Content type

Image

Digest

Size

147.6 MB

Last updated

about 5 years ago

docker pull devzyj/mysql:5.7.35