1.复制一份MySQL服务文件,放入一个路径
2.清理data文件夹下文件,仅保留mysql等
3.修改my.ini,port,...dir等配置
4.管理员运行cmd,cd>bin:mysqld install [servername]
(5.修改regedit[servername]的ImagePath[mysqld][ini])(可省略)
6.启动
C:\Users\Administrator>cd Desktop
C:\Users\Administrator\Desktop>cd [server filepath]
C:\Users\Administrator\Desktop\[server filepath]>cd bin
C:\Users\Administrator\Desktop\[server filepath]\bin>mysqld install [server name] (--defaults-file="..\my.ini")
Service successfully installed.
(regedit.exe
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\[server name]
ImagePath "C:\Users\Administrator\Desktop\[server filepath]\bin\mysqld"
--defaults-file="C:\Users\Administrator\Desktop\[server filepath]\my.ini" [server name])
>net start [server name]
删除服务:sc delete [server name]
创建服务:sc create [server name] binPath="C:\Users\Administrator\Desktop\[server filepath]\bin\mysqld.exe" Type=share Start=auto
查询端口占用:netstat -ano|findstr "[string]"