windows 2008 R2下手机配置mysql
E:/servsoft/mysql-5.6.42-winx64/bin>mysqld -install mysql --default-file= "E:/servsoft/mysql-5.6.42-winx64/bin/my.ini"
不提示安装成功，没有报错
将命令修改为以下
E:/servsoft/mysql-5.6.42-winx64/bin>mysqld -install mysql --default-file= "E:/servsoft/mysql-5.6.42-winx64/my.ini"
安装成功
basedir = "E:servsoftmysql-5.6.42-winx64"
datadir = "E:servsoftmysql-5.6.42-winx64data"
port = 3306
server_id = 100
explicit_defaults_for_timestamp=true
# 设置mysql客户端默认字符集
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
#用于错误信息的语言
lc-messages= en_US
lc-messages-dir =E:servsoftmysql-5.6.42-winx64share
#MYSQL数据导出与导入
secure-file-priv=E:servsoft emp
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
