Home  >  Article  >  Database  >  Detailed example of how to create the my.ini file in the MySQL5.7.19 installation directory

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

黄舟
黄舟Original
2017-08-10 15:30:136430browse

In the last article, I introduced you to the detailed tutorial on the configuration method of MySQL 5.7.19 installation-free version (64-bit). This article focuses on introducing you to the method of creating the my.ini file in the MySQL 5.7.19 installation directory. You can refer to it. Down.

The basic content is as follows


[mysqld]
character-set-server=utf8
#绑定IPv4和3306端口
bind-address = 0.0.0.0
port = 3306
# 设置mysql的安装目录
basedir=F:/test/mysql-5.7.19-winx64
# 设置mysql数据库的数据的存放目录
datadir=F:/test/mysql-5.7.19-winx64/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]
default-character-set=utf8

Summary

The above is the detailed content of Detailed example of how to create the my.ini file in the MySQL5.7.19 installation directory. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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