I am setting up a web staging environment and want to have a duplicate but separate MySQL service on the same machine. Development environments will connect to one service and staging environments will connect to another. This way when setting up a staging environment, I don't need to change database names, just the port on the MySQL server I connect to.
Is this easy and possible? I plan on manually copying the databases over to the staging environment when ready.