在Windows Server上使用MySQL Installer是不能够安装的。所以是需要一些技巧的。
Step 1:正常安装配置MySQL,默认的服务名为MySQL,假如MySQL安装目录为 D:\Program Files\MySQL_1\MySQL Server 5.5。基本配置如下:
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/Program Files/MySQL_1/MySQL Server 5.5/"
#Path to the database root
datadir="D:/Program Files/MySQL_1/MySQL Server 5.5/Data/"
Step 2:在控制面板中停掉MySQL服务
Step 3:复制D:\Program Files\MySQL_1 为D:\Program Files\MySQL_2。并把my.ini中的相应配置改为:
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3307
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/Program Files/MySQL_2/MySQL Server 5.5/"
#Path to the database root
datadir="D:/Program Files/MySQL_2/MySQL Server 5.5/Data/"
Step 4:在cmd窗口中打入
D:\Program Files\MySQL_2\MySQL Server 5.5\bin>mysqld install MySQL2 --defaults-file=
"D:\Program Files\MySQL_2\MySQL Server 5.5\my.ini"
这样就成功了。注意在防火墙中把对应的端口打开。
这种做法对于一种场景特别有用:
有N个公司的数据库分别在不同的物理机上,那么使用单一机器上安装多个MySQL实例为每个公司做为Slave