Detailed example of how to create the my.ini file in the MySQL5.7.19 installation directory

In the last article, I introduced you to the detailed tutorial on the configuration method of MySQL 5.7.19 installation-free version (64-bit). This article focuses on introducing you to the method of creating the my.ini file in the MySQL 5.7.19 installation directory. You can refer to it. Down.

The basic content is as follows

[mysqld]
character-set-server=utf8
#绑定IPv4和3306端口
bind-address = 0.0.0.0
port = 3306
# 设置mysql的安装目录
basedir=F:/test/mysql-5.7.19-winx64
# 设置mysql数据库的数据的存放目录
datadir=F:/test/mysql-5.7.19-winx64/data
# 允许最大连接数
max_connections=200
# skip_grant_tables
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[mysql_safe]
default-character-set=utf8
[client]
default-character-set=utf8

Summary

The above is the detailed content of Detailed example of how to create the my.ini file in the MySQL5.7.19 installation directory. For more information, please follow other related articles on the PHP Chinese website!