Thursday, February 23, 2012

Installing Multiple Mysql on same Machine

It took me lot of time figuring out how to install multiple mysql instances on same machine.
So I thought of sharing Process for setting up multiple Mysql on same machine will be useful for somebody looking for such manual...

1. Install Mysql server on that machine
2. Create a folder called xyz anywhere.
3. Create 2-3 folders...say data1, data2 etc inside xyz folder...they will hold the data for respective tables of respective installation.
4. Create 3 files my1.ini, my2.ini, my3.ini inside xyz folder.
5. Find out my.ini of your original Mysql server installation. And copy the content into all 3 ini files.
6. Modify following configurations in all 3 ini files according to your convenience. Here is example..
[client]
# password = your_password
port = 3307
enable-named-pipe
socket = "C:/xampp/mysql/mypipe1"
[mysqld]
port= 3307
socket = "C:/xampp/mysql/mypipe1"
datadir="C:/mysql1/data1"
pid_file="mysql.pid1"
log_error="mysql_error.log1"
log-bin=master1-bin
server-id = 1
innodb_data_home_dir = "C:/mysql1/data1"
innodb_log_group_home_dir = "C:/mysql1/data1"

Each ini file will contain respective unique entry for port, datadir, socket, server-id etc..
7. Copy mySqlInstallationFolder/mysql/data/mysql folder into all 3 folders data1, data2 and data3.
8. Go to comand prompt and run these commands
Mysqlpath\mysql\bin\mysqld --install mysqld1 --defaults-file=yourPath\xyz\my1.ini [ for Windows...u can find equivalent Linux command for installing a new service ]
Mysqlpath\mysql\bin\mysqld --install mysqld2 --defaults-file=yourPath\xyz\my2.ini
Mysqlpath\mysql\bin\mysqld --install mysqld3 --defaults-file=yourPath\xyz\my3.ini

9. Start your respective service ie mysqld1,mysqld2,mysqld3 [these are all different instances of mysql].
10. Login to individual mysql server using following command
mysql -u root -h localhost -P 3307 [change your port name]
mysql -u root -h localhost -P 3307 -p [ if you have password for root ]

58 comments:

  1. Thanks Mukesh, it works great !!

    ReplyDelete
  2. which mysql version u r using?

    ReplyDelete
    Replies
    1. It is version independent. I suppose I might have tried for mysql 5.5 or 5.6.

      Delete
  3. Did this on Windows under MySQL 5.7. For step 8 I had to enclose the path in quotes, as in: Mysqlpath\mysql\bin\mysqld --install mysqld1 --defaults-file="yourPath\xyz\my1.ini"

    For Step 10: mysql --port=3307 --host=127.0.0.1 --user=root --password

    ReplyDelete
  4. If your echo won't connect to wifi Or having any problem to setup Alexa to Wifi then Don't Worry we are here to help you just follow the simple steps which is given on our website. We'll help you to connect Alexa to wifi, connect echo to wifi and amazon echo not connecting to wifi and other problems. For instant help, call us at our amazon echo help number +1-888-745-1666.
    Setup echo
    Setup Echo Dot

    ReplyDelete
  5. Do not panic if your Echo Look Setup is not running working. We are always here to solve all the problems related to your echo spot like echo Look wifi settings,installation,troubleshooting.Now the solution is at your fingertips. Just pick your phone and call us at :+1-888-745-1666 if you want to Connect Echo Look To Wifi.

    ReplyDelete
  6. Garmin Express is an application which provides
    the ability to access, control and manage all other Garmin
    devices from one place.

    ReplyDelete
  7. Webroot.com/safe – Activate Your Webroot Com Safe on your laptop, PC, Smartphone etc & secure your devices. Let’s

    Get Started with Webroot Safe at www.Webroot.com/safe & Activate Webroot Safe.
    Webroot.com/safe

    ReplyDelete
  8. AVG Retail Registration at avg.com/retail and register your
    AVG Product. Let's Get Started with www.avg.com/retail in order
    to Activate AVG. ... www.avgcomretail.xyz is an independent support
    provider on On-Demand.
    www.avg.com/retail

    ReplyDelete
  9. McAfee.com/activate – McAfee provides complete virus protection and internet security to all your devices. Know more about McAfee, McAfee Activation and McAfee Product Key here.
    mcafee.com/activate

    ReplyDelete
  10. Did you want to Setup Amazon Echo Tap or know about how to download Alexa app for window & PC? Visit www.amazon.com/echosetup & follow some important steps to Setup Amazon Echo. If you are still confused then you can directly help from Amazon Alexa Tap support helpline detail at +1-888-409-8111

    ReplyDelete
  11. Just Call at once +1-877-718-7117 USA All Browser Customer care executives for fast assist and support offerings via Toll Free Phone. By Https Browser
    Https Browser
    Google Chrome Customer Service Number
    Mozilla Firefox Customer Service Number
    Safari Customer Service Number
    Internet Explorer Customer Service Number

    ReplyDelete
  12. Nice post! Get Step-by-Step guide for Office – Activate, Download & complete installation from office.com/setup and get the best security setup for any of your preferred devices just by visiting mcafee.com/activate & norton.com/setup .

    ReplyDelete
  13. Hi
    I read your post and found it quite interesting.
    The post you shared is very unique and informative.
    Thanks for sharing such a useful post.
    mcafee.com/activate
    office.com/setup
    norton.com/setup
    mcafee.com/activate

    ReplyDelete
  14. Download and Install Your Product Online, Setup and Install Product With 3 Simple Steps. Enter Product Key To Start Download, Install Product, Activate and Setup Your Product.
    mcafee.com/activate|www.mcafee.com/activate

    ReplyDelete
  15. McAfee.com/activate – McAfee Antivirus is one of the most critically acclaimed security program across the globe. Protect your devices and data from viruses, malware, Trojan horses, worms, and other cyber threats with real-time protection and threat scanning. Get robust protection offered by McAfee by following the process (download, install, activate) on  mcafee.com/activate |  www.mcafee.com/activate

    ReplyDelete
  16. Find how to download, introduce, activate all renditions of Microsoft Office setup and initiate on  office.com/setup |  www.office.com/setup

    ReplyDelete
  17. mcafee.com/activate - Follow these basic strides to download, establishment and enact your mcafee item. for more data visit: www.mcafee.com/activate .

    mcafee.com/activate
    www.mcafee.com/activate

    ReplyDelete
  18. office.com/setup To get started with your Microsoft Office Installation you must need valid product key code & visit www.office.com/setup and we can also help you with your entire process to setup office product online.

    office.com/setup

    www.office.com/setup

    ReplyDelete
  19. I really enjoyed reading your article. I found this as an informative and interesting post, so I think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article…
    Thank you so much for providing great information about "Mysql Research" .
    mcafee.com/activate | norton.com/setup | office.com/setup | office.com/setup

    ReplyDelete
  20. Download and Install Your Product Online, Setup and Install Product With 3 Simple Steps. Enter Product Key To Start Download, Install Product, Activate and Setup Your Product.
    mcafee.com/activate|www.mcafee.com/activate

    ReplyDelete
  21. Our Professional team is here to Provide 24/7 Technical support for how to
    download Alexa app for windows 10 and setup echo dot. If you are confused during amazon echo setup you can instantly call us at our toll-free number: 1-844-239-8999.

    ReplyDelete
  22. Find how to download, introduce, activate all renditions of Microsoft Office setup and initiate on  office.com/setup |  www.office.com/setup

    ReplyDelete
  23. For complete Amazon Echo Setup, Amazon Echo Dot Setup, Setup Echo Plus, Echo Show Setup, Echo Wifi Setup, Alexa Dot Setup, Echo Setup etc. Simply visit alexa.amazon.com. You can directly call at toll-free no. +1-888-745-1666
    Download Alexa App
    http//alexa.amazon.com
    http //alexa.amazon.com download
    http www.alexa.amazon.com

    ReplyDelete
  24. McAfee.com/activate – McAfee Antivirus is one of the most critically acclaimed security program across the globe. Protect your devices and data from viruses, malware, Trojan horses, worms, and other cyber threats with real-time protection and threat scanning. Get robust protection offered by McAfee by following the process (download, install, activate) on  mcafee.com/activate |  www.mcafee.com/activate

    ReplyDelete
  25. Set up your Alexa device using the Amazon Alexa App, Download the Alexa App from Microsoft Store for Windows 10. To learn more about how to setup Amazon Echo Dot Setup for your PC, visit: alexa.amazon.com. Call us at 1-888-409-8111 if you have any query regarding Amazon Alexa App Setup.

    ReplyDelete
  26. My friend tell me about this blog. There is a lot of good information on this blog, I loved reading it and I think people will get a lot of support from this blog. I really like it features from this too. I hope you like this blog. I hope you got a lot of help from this blog.
    https://www.mcafeecom.net/activate/

    ReplyDelete
  27. This is Great post, i will Read it i hope you will Write new post in some days I will wait your post. Thank you for sharing this blog 
    office.com/setup | norton.com/setup |mcafee.com/activate |

    ReplyDelete
  28. Hi
    A debt of gratitude is in order for perusing this blog I trust you discovered it bolsters and supportively data. I have perused your blog great data in this (QuickBooks Update Support) blog. It was great learning from this blog. Your blog is a decent motivation for this blog.

    ReplyDelete
  29. Hi
    My companion has lauded your blog and I need to peruse your blog. There is a great deal of good data on your blog, I adored understanding it and I figure individuals will get a ton of assistance from this blog. Sam, I have composed this sort of blog, I figure you will get a great deal of assistance from this as well. I trust you like this (McAfee.com/Activate) blog, Users will get a great deal of data from this blog. I trust you like my blog. I trust you got a ton of assistance from this blog.

    ReplyDelete
  30. Hi
    A debt of gratitude is in order for perusing this blog I trust you discovered it bolsters and supportively data. I have perused your blog great data in this Change your world with Facebook live blog. It was great learning from this blog. Your blog is a decent motivation for this blog.

    ReplyDelete
  31. We have a professional and well-trained team player to help you in amazon echo setup, and download alexa app. You can visit us at http://alexa.amazon.com and can also call us at our toll-free +1-888-381-1555.
    echo dot setup
    amazon alexa setup
    amazon alexa app
    amazon echo dot
    amazon alexa setup
    alexa app
    alexa setup
    echo dot


    ReplyDelete
  32. Click below link and Enter 25 digit McAfee key code to install and setup McAfee antivirus.
    mcafee.com/activate
    www.mcafee.com/activate

    ReplyDelete
  33. Amazon Alexa Setup, Echo Dot Setup, Amazon Alexa App, Setup Echo Plus, Echo Show Setup, Echo Tap Setup, Alexa App all are very easy to install and Setup Simply visit alexa.amazon.com and for Instant, help call at toll-free no. +1-888-745-1666.
    Download Alexa App
    http//alexa.amazon.com
    http //alexa.amazon.com download
    Amazon Alexa Setup

    ReplyDelete
  34. Hi
    My friend has praised your blog and I want to read your blog. There is a lot of good information on your blog, I loved reading it and I think people will get a lot of help from this (Facebook customer service) blog. Sam, I have written this kind of blog, I think you will get a lot of help from this too. I hope you like my blog, Users will get a lot of information from this blog. I hope you like my blog. I hope you got a lot of help from this blog.

    ReplyDelete
  35. Hello dear,
    I expected to scrutinize your blog, I savored the experience of examining your blog. there is a huge amount of good information on your blog, I appreciated understanding it and I figure people will get a huge amount of help from this (McAfee.com/Activate) blog. Sam, I have made this deal with of blog, You can in like manner scrutinize this blog. I figure you will get a lot of help from this also. I believe you like my blog, I believe you got a huge amount of help from this blog.

    ReplyDelete
  36. Nice post! I read your blog.

    Here you know all about the amazon alexa setup step by step. You can visit our blog and get information about Amazon echo dot setup. Instant Help: 1-844-239-8999.
    alexa.amazon.com
    download alexa

    app for windows 10

    amazon alexa setup
    echo dot setup
    amazon alexa app

    ReplyDelete
  37. Your selection of topic is very good and also well written. Thanks for sharing. I feel like all your ideas are incredible! Great job.
    norton.com/setup
    mcafee.com/activate

    ReplyDelete
  38. Thank you for sharing this information. I read your blog and I'm not stopped my self to read your full blog. Again Thanks and Best of luck your next Blog in future.
    Subzero Wolf
    Built-in Refrigerator
    Integrated Refrigerator
    Wine Storage Refrigerator
    Professional Models Refrigerator

    ReplyDelete
  39. The Garmin GPS gadgets should be exceptional so as to convey the precise information while driving or climbing. Garmin has a few Maps or Gps gadgets like Garmin Nuvi. In the event that you have Garmin Nuvi gadget and you need to introduce the Garmin Nuvi Update on your gadget then you can utilize Garmin Express.

    ReplyDelete
  40. Thanks for sharing with Us. looking for McAfee Activate and if you facing any issues due to McAfee download, install, activate can go to the following link
    www.mcafee.com/activate | mcafee.com/activate | McAfee Activate | McAfee download

    ReplyDelete
  41. Windows 10 - If you facing any issues due to uninstall Windows 10 can visit the following link

    How to uninstall Windows 10?

    ReplyDelete
  42. Nice one! thank you so much! Thank you for sharing this post. Your blog posts are more interesting and impressive.
    norton.com/nu16 | office.com/setup | norton.com/setup | mcafee.com/activate |office.com/setup |mcafee.com/activate

    ReplyDelete
  43. Garmin.com/express
    - The Garmin is the American Company that offers Global Positioning System (GPS), GPS receivers, satellite navigation products, and other consumer electronics. These devices are used and praised by many because of their quality product. Furthermore, the Garmin understands the requirement of their users and gives out an application to manage the Garmin devices. That application is known by name Garmin Express.

    ReplyDelete
  44. mcafee.com/activate
    - McAfee Antivirus Offers the cyber security solution for the protection of your digital data. The company developed a number of software and services to fulfill the requirements of the users. You can download and install the security on your system from the link mcafee.com/activate online. In order to download and activate your version of the product on your system, you need a unique product key.

    ReplyDelete
  45. mcafee.com/activate
    -offers high-end protection against all kinds of online threats, Ransomware attack and other viruses lurking in the digital world. These viruses attack directly or indirectly on your computer system with an intention of corrupting your important data and stealing your confidential information. Sometimes, viruses like Ransomware can permanently lock your system for asking you pay ransom to get the access back.

    ReplyDelete
  46. Nice one! thank you so much! Thank you for sharing this post. Your blog posts are more interesting and impressive.
    norton.com/nu16 | office.com/setup | norton.com/setup | mcafee.com/activate |office.com/setup |mcafee.com/activate

    ReplyDelete
  47. Get Step-by-Step guide for Norton.com/setup – Activate, Download & complete installation from norton.com/setup and get the best security setup for any of your preferred devices just by visiting norton.com/setup & mcafee.com/activate . Also try our step by step guide for office.com/setup .

    ReplyDelete
  48. Call at our QuickBooks Pro support number 1-888-412-7852 (Toll Free) and get hassle-free 24x7 QuickBooks Desktop Pro technical help to fix issues by certified Pro advisors.

    ReplyDelete
  49. Microsoft Office is one amongst the most useful productivity suites for Mac and Windows. Log in at  office.com/setup and browse various packages for Office 2019, Office 365, Office 2016, Office 2013, Office 2010 and more. After downloading and installing its setup, activate it with the product key.

    ReplyDelete
  50. To get Alexa Setup, Echo Setup, Echo Dot Setup, Alexa App, Alexa Download, Amazon Alexa Setup, Amazon Echo Dot then Download Alexa App from alexa.amazon.com download. For Instant, help call at toll-free no. +1-888-745-1666.
    Download Alexa App
    http//alexa.amazon.com
    http //alexa.amazon.com download
    Amazon Alexa Setup
    Echo Dot Setup
    Alexa Download

    ReplyDelete
  51. You know, I had one other person saying this (in a less friendly way) and I figured it was just another case of somebody actively seeking to be offended in some way by completely misreading the context of the statement. Which is obviously not written with a goal to offend the group you describe. But that website does provide a useful background, so you changed my mind.


    office.com/setup

    ReplyDelete