• notice
  • Congratulations on the launch of the Sought Tech site

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!

Tags

Technical otaku

Sought technology together

Related Topic

0 Comments

Leave a Reply

+