Windows

對於多個 mysql 實例,存在一個時需要重新下載嗎?

  • June 9, 2017

我需要在同一台伺服器上的多個 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.

我自己的分析是全新安裝,但請確認。

我所做的是:

      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

按照這個簡單的步驟,在同一台伺服器上做多個實例會更容易 http://bingobo.info/blog/recipes/how-to-set-up-separate-mysql-instance-on-windows.jsp

引用自:https://dba.stackexchange.com/questions/105199