Re: MySQL multiple instances in Ubuntu Server
I have followed this tutorial step-by-step and I am sure I haven't missed any step but I still cannot get it to work.
I am sure I am having problems with pid and socket files and the datadir.
When I set the datadir to the original folder /var/lib/mysql and use the original pid and socket file, the instance starts correctly but if I change to what the tutorial suggests (/var/lib/mysql1 - /var/run/mysqld/mysqld1.pid and /var/run/mysqld/mysqld1.sock), nothing works.
One doubt, might be stupid but, do I need to install mysql twice, one for each pair of pid and socket?
I have only installed mysql once using apt-get and then tried the tutorial.
Do you guys have any idea what I am doing wrong?
Any help is very much appreciated.
Tags for this Thread