Multiple MySQL Server Instances
Updated on: May 03, 2022
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/"
Start the Services
Start the services:
>net start MySQLone <enter>>net start MySQLtwo <enter>