Mysql5.7 lacks a solution for My.ini files
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 my.ini file, so I need to create it myself.
The general content is as follows
[mysqld] character-set-server=utf8 #Binding 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 # Allow the 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 = 3306 plugin-dir=G:\Tool\Mysql\lib\plugin
Summary
The above is the solution to MySQL5.7 lacking my.ini file introduced by the editor.I hope it will be helpful to you.If you have any questions, please leave me a message, and the editor will reply to you in time.Thank you very much for your support to the website!
0 Comments