How to Install Multiple MySQL Servers on a Windows Machine - MySQL DBA Tutorial

How to Install Multiple MySQL Servers on Windows Machine


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:\programfile\MySQL\ MySQL Server XX 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, I have updated to 3307
  5. 5Change 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 by using     ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';


How to install multiple MySQL Servers on single Windows Machine

13 comments:

  1. Richard LeeSeptember 22, 2019 at 11:32 PM

    hi, how to solve the error after run the net start MYSQLQA.
    The error is:
    The service did not report an error. More help is available by typing NET HELPMSG 3534.

    ReplyDelete
    Replies
    1. KaliNovember 14, 2021 at 1:53 AM

      Your article and tips are incredibly interesting, are helping me a lot. It's very informative. Thanks for the detailed info on this topic. It’s hard to find nowadays to know about the basics but you did it so much well. I would love to see more about FMWhatsapp 2022. Keep sharing and updated. Also share more posts with us. Thank you.

      Delete
    2. devilNovember 15, 2021 at 1:34 AM

      Your post is helping me a lot. Its really nice and epic. Thanks a lot for the useful info on this topic. You did it so much well. I love to see more about GBWhatsApp 2022. Keep sharing and updating. Also share more posts with us. Thank you.

      Delete
  2. UnknownJanuary 5, 2020 at 12:09 AM

    It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. unmetered dedicated servers

    ReplyDelete
  3. suvankarApril 18, 2020 at 10:05 AM

    hi, how to solve the error after run the net start MYSQLQA.
    The error is:
    The service did not report an error. More help is available by typing NET HELPMSG 3534.

    ReplyDelete
  4. UnknownAugust 1, 2020 at 6:59 AM

    Got this error. instal/remove of the Service denied!
    when running this command
    mysqld --install MYSQLDEV --defaults-file="c:/MYSQLDEV/mysqldev.ini"

    please help

    ReplyDelete
    Replies
    1. VARUN GUPTAJune 17, 2021 at 4:42 AM

      open command with admin and change directory to bin folder and do these command again

      Delete
  5. Larry AlexanderNovember 4, 2020 at 8:35 PM

    This comment has been removed by the author.

    ReplyDelete
  6. Larry AlexanderNovember 4, 2020 at 10:47 PM

    This comment has been removed by the author.

    ReplyDelete
  7. HuongkvJuly 21, 2021 at 7:34 PM

    Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế

    vé máy bay đi Mỹ giá rẻ

    đặt vé máy bay từ mỹ về việt nam

    khi nào có chuyến bay từ đức về việt nam

    giá vé máy bay nga về việt nam

    khi nào có chuyến bay từ anh về việt nam

    các chuyến bay từ châu âu về việt nam

    khách sạn cách ly ở nha trang

    ReplyDelete
  8. oscar clarkJanuary 3, 2022 at 1:57 AM

    This comment has been removed by the author.

    ReplyDelete
  9. oscar clarkJanuary 3, 2022 at 1:59 AM

    This comment has been removed by the author.

    ReplyDelete
  10. YoWAPlusFebruary 24, 2022 at 1:25 AM

    That setting makes it easy for me to use multiple nicks to login yo whatsapp, gb whatsapp, whatsapp plus,.... on YoWAPlus home page

    ReplyDelete

Subscribe to: Post Comments (Atom)