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

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?

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

Summary

The above is the solution to the lack of my.ini files in MySQL5.7 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!

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.