MySQL5.7 is missing the solution for my. ini file, mysql5.7my. ini

MySQL5.7 is missing the solution for my. ini file, mysql5.7my. ini

What is my. ini?

My. ini is the configuration file used in the MySQL database. You can modify this file to update the configuration.

Where is my. ini stored?

My. ini is stored in the root directory of MySql installation ,:

The my. ini file is missing in MySQL 5.7 that I installed and needs to be created by myself.

The general content is as follows:

[Mysqld] character-set-server = utf8 # bind IPv4 and port 3306 bind-address = 0.0.0.0port = 3306sql_mode = "STRICT_TRANS_TABLES, NO_ENGINE_SUBSTITUTION "default_storage_engine = bytes = 1000Minnodb_log_file_size = 50 M # Set the installation directory of mysql # basedir = F:/test/mysql-5.7.19-winx64 # Set the data storage directory of the mysql database 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 = 3306plugin-dir = G: \ Tool \ Mysql \ lib \ plugin

Summary

The above is a small series of MySQL5.7 lack of my. ini file solution, I hope to help you, if you have any questions, please leave a message, the small series will reply to you in a timely manner. Thank you very much for your support for the help House website!