I just installed MySQL 5.7 on Windows 2012 VM. I am trying to create and run multiple instances but very frustrated that such a simple thing is not working.

I installed MySQL in C:\Program Files\MySQL\MySQL Server 5.7 which is default location and then I copied the folder and made another copy of it to create another instance (I suppose this is how it works?)

Both MySQL instances are shown in image below.

Server1 Server1


INI settings for both servers are given below:


auto-increment-increment = 2
auto-increment-offset = 1

auto-increment-increment = 2
auto-increment-offset = 2

I am running both servers by opening command prompt and typing following:
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld"
"C:\Program Files\MySQL\MySQL Server 5.7 - 2\bin\mysqld"

The command seems to run successfully as no error is shown but when I look at task manager to see if any mysql processes are running, I see none.

What am I doing wrong?

  • Please edit your question to include error logs etc.
    – EEAA
    Dec 31 '16 at 21:36
  • Issue is solved. Dec 31 '16 at 21:40
  • Would you like me to open the question so you can post an answer?
    – EEAA
    Dec 31 '16 at 21:41
  • Yes so I can post answer. Jan 1 '17 at 9:30

The mistake I was doing was to copy whole MySQL installation folder. You don't need to copy this folder.

  • Simply create a new ini file for each instance that you want to run (examples given above) at any location for e.g. C:\MyInstances\my1.ini.
  • Then create a new folder for e.g. data1 in C:\MyInstances\data1 and copy mysql and information_schema databases in it. You will get these databases from data folder where MySQL is installed. On Windows 2012 (and probably other server OS) it typically is C:\ProgramData\MySQL
  • Then define the following in your ini file.


  1. Then run following command which will install MySQL as service. After services is created simply run the service.

MySqlpath\bin\mysqld --install mysqld1 --defaults-file=PATH_TO_YOUR_INI_FILE

Of course in each ini file, you have to define a different port number as mentioned by @Anthony Fornito.


I believe you were trying to run them on the same port.

Changed the ports numbers to be different was what made it work

  1. Create a separate data folder and give FULL CONTROL to NETWORK SERVICE.
  2. Copy the my.ini file to the new data folder.
  3. Create a new file in the data directory called mysql-init.txt and add a single line to ensure that the password of the root user is set.

    • ALTER USER 'root'@'localhost' IDENTIFIED BY '[Enter Password]';
  4. Edit the my.ini file by changing the port, socket, datadir, and shared memory base name. All of which need to be different from other instances of MySQL.



basedir="C:/Program Files/MySQL/MySQL Server 5.7"
  1. From the command line navigate to ~\MySQL Server X.Y\bin\ and run

    • mysqld --install MySQL57-2 --defaults-file=E:\mysql2\data\my.ini --init-file=E:\mysql2\data\mysql-init.txt
  2. Start the service

    • NET START MySQL57-2
  3. Check to make sure the service started successfully. If it didn’t then you can find an error log in the data folder else you should be good to go.

  • followed it, but not able to start the new service getting, PS C:\MySQLInstances\data> net start mysqld The mysqld service is starting. The mysqld service could not be started. The service did not report an error. More help is available by typing NET HELPMSG 3534.
    – Rajat
    Sep 25 '18 at 9:24

My steps on Windows 10:

  1. Copy C:\ProgramData\MySQL\MySQL Server 8.0\my.ini to C:\ProgramData\MySQL\MySQL Server 8.0\my1.ini
  2. Open my1.ini and modify:
    • port=3307(under Client and Server Section)
    • datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data1
    • report_port=3307
  3. Copy C:\ProgramData\MySQL\MySQL Server 8.0\Data to C:\ProgramData\MySQL\MySQL Server 8.0\Data1
  4. Run on cmd prompt: (With Administrator privileges if necessary)
    C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --install MySQL80-1 --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my1.ini"

If all went well, you will see:
Service successfully installed.

  1. Win+R
    Type services.msc, find the service name MySQL80-1, right-click on it and click Start.

If all went well, you will see the Status change to Running.
If it did not go well, open xxx.err file found in C:\ProgramData\MySQL\MySQL Server 8.0\Data1 to check why.

If you do not want the service anymore:

  • Stop it
  • Delete it on the cmd prompt using sc delete MySQL80-1 where MySQL80-1 is your service name.
  • This worked for me! Only I needed to type the following instead of point 4: "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --install MySQL80-1 --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my1.ini"
    – Jossy
    Jul 24 '20 at 11:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.