There are various method to setup multiple of mysql instances on a single linux ubuntu server. In this scope of this page, i will show you the most simple one. You can follow the steps below to get it done: 1. Create separate data and log directories We need to create new directories for our datadir and log folder (if used). Also we need to assign proper permissions on those folders: mkdir /var/lib/mysql2 chown -R mysql.mysql /var/lib/mysql2/ mkdir /var/log/mysql2 chown -R mysql.mysql /var/log/mysql2 2. Create a new mysql configuration file Next we need a separate configuration file. We can start by copying the existing one andRead More →