1 删除之前的MYSQL服务 sc delete mysql
2 关联mysql.ini路径
方式一:sc create MySQL binPath= "\"D:\mysql\bin\mysqld\" --defaults-file=\"D:\mysql\my.ini\" MySQL" displayname= "MySQL" depend= Tcpip start= auto
方式二(适合免安装版): D:\mysql\bin\mysqld --install MySQL --defaults-file=D:\mysql\my.ini
3 mysql.ini文件参考设置
[WinMySQLAdmin]
Server=D:/mysql/bin/mysqld.exe
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8
[mysqld]
port=3306
basedir=D:/mysql
log="c:/mysql_query.log"
#tmpdir=D:/mysql/temp/
max_allowed_packet=128M
datadir=D:/mysql/data
default-character-set=utf8
#default-storage-engine=INNODB
max_connections=100
read_buffer_size=64K
read_rnd_buffer_size=256k
innodb_thread_concurrency=8