Hi all,

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.