配置文件

windows的配置文件

mysql的配置文件ini 默认配置

[client]
port=3306
socket=/usr/local/mysql/mysql/data/mysql/mysql.sock
[mysqld]
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=G:\mysql\mysql-5.7.19-winx64
# 设置mysql数据库的数据的存放目录
datadir=G:\mysql\mysql-5.7.19-winx64\data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
#开启查询缓存
explicit_defaults_for_timestamp=true
skip-grant-tables
[mysqld_safe]
log-error=/usr/local/mysql/mysql/data/mysql/mysqld.log
pid-file=/usr/local/mysql/mysql/data/mysql/mysqld.pid

linux的配置

[client]
port=3306
socket = /var/run/mysqld/mysqld.sock

default-character-set = utf8mb4

[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock

#datadir = /var/lib/mysql

#socket = /software/mysql/mysqld.sock

#pid-file = /software/mysql/mysqld.pid

datadir = /software/mysql/data

character_set_server = utf8mb4

collation_server = utf8mb4_unicode_ci

secure-file-priv= NULL

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Custom config should go here

!includedir /etc/mysql/conf.d/