Shulou(Shulou.com)06/01 Report--

Editor to share with you to solve the problem of lack of my.ini files in MySQL5.7, I hope you can learn a lot after reading this article, let's discuss it together!

What is my.ini? My.ini is the configuration file used in the MySQL database, and you can update the configuration by modifying this file. Where is the my.ini stored?

Related mysql video tutorials

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

My installation of MySQL 5.7lacks the my.ini file and needs to be created by myself.

The general content is as follows

[mysqld] character-set-server=utf8# binds IPv4 and port 3306 bind-address = 0.0.0.0port = 3306sqlroommode = "STRICT_TRANS_TABLES NO_ENGINE_SUBSTITUTION "default_storage_engine=innodbinnodb_buffer_pool_size=1000Minnodb_log_file_size=50M# setup mysql installation directory # basedir=F:/test/mysql-5.7.19-winx64# set mysql database data storage directory datadir=G:\ Tool\ Mysql\ data# allowed maximum number of connections 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 has finished reading this article I believe you have some understanding of solving the problem of lack of my.ini documents in MySQL5.7. If you want to know more about it, you are welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.