How to Install Multiple MySQL Servers on Windows Machines – MySQL DBA Tutorial



How to Install Multiple MySQL Servers on Windows Machines – MySQL DBA Tutorial demo explains the limitations that we can’t install the MySQL multiple Servers on same machine by using MySQL Installer. Below are the steps you have to perform to install another MySQL server on windows machine on which you already have installed MySQL.

1) Create a new folder on C drive, let’s say MYSQLDEV
2) Copy all the folders from c:programfileMySQL to MYSQLDEV
3) Search for my.ini in %PROGRAMDATA%MySQL and copy to MYSQLDEV and also copy Data directory
4) Change the port for [client] and [mysqlid] in mysqldev.ini file
5) change the basedir and datadir location to new location
6) execute mysqld –install MYSQLDEV –defaults-file=”c:/MYSQLDEV/mysqldev.ini”
7) Start the services net start MYSQLDEV
8) Connect to MySQL mysql -u root –Port=3307
9) Run show variables where variable_name in (‘hostname’,’port’);
10) Change the root password if you need to for newly installed MySQL service
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass’;

To follow step by step tutorial for MySQL DBA for beginner to Advance
http://www.techbrothersit.com/2018/11/mysql-dba-tutorial-beginner-to-advance.html

MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin

19 thoughts on “How to Install Multiple MySQL Servers on Windows Machines – MySQL DBA Tutorial

  1. Errata corrige for point 8 in description: mysql -u root -p –port=3307 (without "-p" and with "Port" you have errors). Thank you very much for your help!

  2. I have installed MySQL 5.5 on my server. How can I install another instance of MySQL 8.0 on the same server? From this video i can see you have installed MySQL8.0 from MySQL 8.0. Thanks!

  3. Man I was really needing this. I was struggling with the fact that the MySQL installer doesn't let you install more than 1 instance.

    You explained everything very well!

Leave a Reply

Your email address will not be published. Required fields are marked *