Assumptions
OS: Ubuntu 16.x edition– up to dateAlready has MySQL installed that comes default – you can easily install LAMP MySQL Server version: > 5.5You have OS root privilegesDefault MySQL is running on port 3306What will we do
Set up 1 more MySQL instances on ports 3407 Each instance will have their own config files, data directories and log directoriesStopping default MySQL instance
sudo service mysql stop
sudo ps -A | grep mysqlCreating data directories
MySQL cannot share data directories, so we need to set up new onesdefault basedir = /usr, this can be shared across instancesdefault instance port = 3306 and data dir = /var/lib/mysqlnew instance port = 3408 and datadir = /var/lib/mysql3408MySQL must own data dirswe need to set rules in apparmor to let MySQL access the new dirssudo mkdir /var/lib/mysql3408
sudo chown -R mysql /var/lib/mysql3408
Creating log directories
create separate log dirs for new MySQL instancesdefault log dir = /var/log/mysqlnew log dir for 3307 = /var/…