# MysqlForinit

**Repository Path**: miacandyfang/mysql-forinit

## Basic Information

- **Project Name**: MysqlForinit
- **Description**: 分享一个配置文件
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-12-11
- **Last Updated**: 2025-12-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# MysqlForinit

[mysqld]
port=3306
# set basedir to your installation path
basedir=D:/ProgramFiles/mysql-8.0.44-winx64
# set datadir to the location of your data directory
datadir=D:/ProgramFiles/mysql-8.0.44-winx64/data
# skip-grant-tables # 密码错误就用这个，不用密码验证身份
# 允许最大连接数
max_connections=200
# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
max_connect_errors=10
# 服务端使用的字符集默认为UTF8
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证
# default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead
default_authentication_plugin=mysql_native_password
# 这个需要注意一下，不然报错
# 其原因是从 5.6开始，timestamp 的默认行为已经是 deprecated 了。
explicit_defaults_for_timestamp=true
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4