mysqld.cnf

[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.1
collation-server = utf8mb4_unicode_ci
init-connect = 'SET NAMES utf8'

basedir = ..
datadir = ../data
port = 3306
character_set_server=utf8mb4

# 免密码登录
#skip-grant-tables

# 时间戳问题, 不然会报错
explicit_defaults_for_timestamp=true
log_timestamps = SYSTEM

# 导入导出数据指定文件夹, 不然会报错
secure-file-priv = ../log

default-time-zone = '+8:00'

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER

# Host '127.0.0.1' is not allowed to connect to this MySQL server
#skip-name-resolve

#如果你没有设置认证方式，默认的密码加密方式是：caching_sha2_password
default_authentication_plugin=mysql_native_password


# 日志
log-output=FILE
## hostname.log
log-error=../log/error.log
slow-query-log-file=../log/slow-query-log-file.log
general-log-file=../log/mysqld.log



[mysql]
default-character-set=utf8
protocol=tcp
user=root