主页 / dba / 问题 / 105199
Accepted
simplifiedDB
Asked: 2015-06-26 23:07:29 +0800 CST

对于多个 mysql 实例，存在一个时需要重新下载吗？

  • 772

我需要在同一台服务器上安装多个 Mysql 实例。我浏览过很多链接，但我在这里感到困惑：

What i have : MySQL 5.6 is already installed on my windows server A.
Installed at : "C:\Program Files (x86)\MySQL\MySQL_Server_5.6\"

Problem :   For multiple instances , do i need to download and install new mysql(either same or higher version) on server A ?

OR
  should i just copy existing my.conf file in new folder and then change its port number and then done.

我自己的分析继续全新安装，但请确认。

windows mysql-5.6

2 个回答

  1. Best Answer

    我所做的是：

           i used existing my.cnf file and copy it in another location and edit
       some part of it :

         1. Commented #port=3306
         2. Added these lines at the end.
           [mysqld1]
           basedir ="C:\Program Files (x86)\MySQL\MySQL Server 5.6"
           port = 3307
           enable-named-pipe
           socket = mypipe1

           [mysqld2] 
           basedir ="C:\Program Files (x86)\MySQL\MySQL Server 5.6"
           port = 3308
           enable-named-pipe
           socket = mypipe2
    • 0

  2. 按照这个简单的步骤，在同一台服务器上执行多个实例会更容易 http://bingobo.info/blog/recipes/how-to-set-up-separate-mysql-instance-on-windows.jsp

    • 0

相关问题