Running Multiple Instance of MYSQL in Same Machine
How to create single mysql server run on multiple port in a machine Description : here , we are going to discuss on how can we run a multiple mysql instance on different port using single mysql version in same machine. If you not have mysql server in your local machine just follow step 1 else you can follow from step 2. Step 1: Installing MYSQL Server: We need to install the mysql server in linux or windows. The below command to use to install in linux machine. 1. sudo apt - get install mysql - server Using this we can install latest version Mysql Server in linux machine. During installation process it prompt the root user password. Step 2: Setting up mysqld_multi : In order to manage two instances effectively in same machine, we need to use mysqld_multi . use this link to read about mysqld_multi . The mysqld_multi used to mange the mysql different group in the same machine. Now, we are going to disc...