Multiple MySQL Server Instances

Set Directories

Land F/X must have a different directory:

C:\LandFXone\

C:\LandFXtwo\

Create the Services

There must be two different services. Create them from the Windows Command Prompt:

>cd c:\Program Files\MySQL\MySQL Server 5.1\Bin <enter>

>mysqld –install MySQLone <enter>

>mysqld –install MySQLtwo <enter>

Modify my.ini

My.ini file must have entries for both services.

Server section

The following options will be read by the MySQL Server. Make sure you've installed the server correctly (see above) so it reads this file.

[mysqlone]

TCP/IP Port: The MySQL Server will listen on port=3306

Path to installation directory. All paths are usually resolved relative to this.

basedir="C:/Program Files/MySQL/MySQL Server 5.5/"

Path to the database root

datadir="C:/LandFXone/Data/"

[mysqltwo]

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="C:/Program Files/MySQL/MySQL Server 5.5/"

Path to the database root

datadir="C:/LandFXtwo/Data/"