Windows
對於多個 mysql 實例,存在一個時需要重新下載嗎?
我需要在同一台伺服器上的多個 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