MySQL 5.7 windows 免安装版 配置文件 案例

以管理员身份运行cmd，进入mysql的bin目录。

#初始化数据库mysqld  --initialize#安装windows服务mysqld -install MySQL    

mysql.ini

[mysqld]character-set-server=utf8#绑定IPv4和3306端口bind-address = 0.0.0.0port = 3306# 设置mysql的安装目录basedir=D:\db\mysql-5.7.20-win32# 设置mysql数据库的数据的存放目录datadir=D:\db\mysql-5.7.20-win32\data# 允许最大连接数max_connections = 768 skip-name-resolvekey_buffer_size = 256M max_allowed_packet = 8M wait_timeout = 600[mysql]default-character-set=utf8[mysql.server]default-character-set=utf8[mysql_safe]default-character-set=utf8[client]default-character-set=utf8