软件——mysql低空配置
[mysqld]
bind-address=0.0.0.0
port=3382
user=mysql
basedir=/home/db/mysql
datadir=/home/db/data/mysql
socket=/tmp/mysql.sock
log-error=/home/db/data/mysql/mysql.err
pid-file=/home/db/data/mysql/mysql.pid
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
group_concat_max_len = 18446744073709551615
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[client]
port=3812
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
socket=/home/db/mysql/tmp/mysql.sock
[mysqld]
port=3812
basedir=/home/db/mysql
datadir=/home/db/mysql/data
tmpdir=/home/db/mysql/tmp
socket=/home/db/mysql/tmp/mysql.sock
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
init_connect=’SET NAMES utf8mb4’
lower_case_table_names=1
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES
group_concat_max_len=18446744073709551615
max_connections=151