Solution to the lack of my.ini file in MySQL 5.7

What is my.ini?

my.ini is the configuration file used in the MySQL database. Modifying this file can achieve the purpose of updating the configuration.

Where is my.ini stored?

my.ini is stored in the root directory of the MySql installation, as shown in the figure:

The MySQL 5.7 I installed lacks the my.ini file and needs to be created by myself.

The general contents are as follows

[mysqld]
character-set-server=utf8
#Bind IPv4 and port 3306 bind-address = 0.0.0.0
port = 3306
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=1000M
innodb_log_file_size=50M
# Set the installation directory of mysql# basedir=F:/test/mysql-5.7.19-winx64
# Set the storage directory of mysql database data datadir=G:\Tool\Mysql\data
# Maximum number of connections allowed max_connections=200
# skip_grant_tables
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[mysql_safe]
default-character-set=utf8
[client]
port = 3306
plugin-dir=G:\Tool\Mysql\lib\plugin

Summarize

The above is the solution to the problem of missing my.ini file in MySQL 5.7 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!