Add or create an additional instance of mysql on a different port
by plisken from LinuxQuestions.org on (#5CS7Z)
I'm looking to have an additional instance of mysql (mariadb) running on a different port with a different data directory.
I have had a couple of unsuccessful attempts at doing this so far and would appreciate any feedback or pointers to a working guide on how to achieve this.
I do recall doing it many years ago on a Slackware box I had but back then, there was only one config file if I recall correctly my.cnf and from what I remember it was pretty straightforward, with all configuration being in that file, so starting the instance was a matter of passing this file as an option.
One thing I do recall being difficult (for me) was setting up different users for the other instance, so will need some info on this also.
I'm doing this on buster if it makes any difference, thanks.
I have had a couple of unsuccessful attempts at doing this so far and would appreciate any feedback or pointers to a working guide on how to achieve this.
I do recall doing it many years ago on a Slackware box I had but back then, there was only one config file if I recall correctly my.cnf and from what I remember it was pretty straightforward, with all configuration being in that file, so starting the instance was a matter of passing this file as an option.
One thing I do recall being difficult (for me) was setting up different users for the other instance, so will need some info on this also.
I'm doing this on buster if it makes any difference, thanks.