Home > Database > Mysql Tutorial > body text

How to solve the problem of missing my.ini file in MySQL5.7

小云云
Release: 2019-02-26 17:12:40
Original
10649 people have browsed it

What is my.ini? my.ini is the configuration file used in the MySQL database. Modifying this file can update the configuration. Where is my.ini stored?

Recommended related mysql video tutorials: "mysql tutorial"

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

The MySQL 5.7 I installed lacks the my.ini file and needs to be created by myself.

The general content is as follows

[mysqld]
character-set-server=utf8
#绑定IPv4和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
# 设置mysql的安装目录
# basedir=F:/test/mysql-5.7.19-winx64
# 设置mysql数据库的数据的存放目录
datadir=G:\Tool\Mysql\data
# 允许最大连接数
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
Copy after login

Related recommendations:
Detailed example of how to create the my.ini file in the MySQL5.7.19 installation directory

MySQL 5.6 & 5.7 optimal configuration file template (my.ini)_MySQL

##Mysql my.ini configuration file detailed explanation

The above is the detailed content of How to solve the problem of missing my.ini file in MySQL5.7. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template