一台主机运行多个mysql_在一台主机上安装多个mysql服务

1.mysql安装(省略)

2.停止mysql服务

3.复制mysql的所有文件到另一个目录(如图)

4.打开复制目录下的my.ini文件修改喎�"/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+ICAgW2NsaWVudF08YnI+CnBvcnQ9MzMwNyAjtdrSu7j2yv2+3b/itcTErMjPtsu/2srHMzMwNgog1eLA79Do0qrB7c3ixvTTw9K7uPa2y7/aPGJyPgojIFRoZSBUQ1AvSVAgUG9ydCB0aGUgTXlTUUwgU2VydmVyIHdpbGwgbGlzdGVuIG9uPGJyPgpwb3J0PTMzMDc8YnI+CiMgUGF0aCB0byBpbnN0YWxsYXRpb24gZGlyZWN0b3J5LiBBbGwgcGF0aHMgYXJlIHVzdWFsbHkgcmVzb2x2ZWQgcmVsYXRpdmUgdG8KIHRoaXMuPGJyPgpiYXNlZGlyPSZxdW90O0Q6XHNlY29uZG15c3FsXE15U1FMIFNlcnZlciA1LjVcJnF1b3Q7ICAgICAgICAgI7Xatv649sr9vt2/4mJhc2VkaXI8YnI+CiMgUGF0aCB0byB0aGUgZGF0YWJhc2Ugcm9vdDxicj4KZGF0YWRpcj0mcXVvdDtEOlxzZWNvbmRteXNxbFxNeVNRTCBTZXJ2ZXIgNS41XGRhdGFcJnF1b3Q7ICAgICO12rb+uPbK/b7dv+JkYXRhZGlyPC9wPgo8cD48aW1nIHNyYz0="/uploadfile/Collfiles/20141204/201412040917468.png" alt="">

5.管理员身份运行cmd创建启动服务

mysqld

install MySQL2 --defaults-file="D:secondmysqlMySQL Server 5.5my.ini"

6.查看服务并打开

7.连接

在连接过程中可能会出现

默认密码为空。