Comments on: Manually installing multiple MySQL instances on Linux: HOWTO

By: shlomi

shlomi — Sat, 02 Nov 2013 07:17:21 +0000

So the problem is not with two MySQL instances, one 32 bit and another 64 bit. The problem is with dependencies on your OS.
To be honest, I’m not sure. It depends on which OS you’ve got. Debian based? RedHat based?
I would suggest trying to set the new instance via mysqlsandbox, and resolve the dependencies one by one. Which packages are failing?

By: Ben

Ben — Wed, 30 Oct 2013 14:48:24 +0000

Hello, should these steps work when installing 32 and 64 bit versions in parallel? I have a system with 32 bit MySQL installed and in production taht cant be touched or changed, I need to import a database that is in excess of 30G. As this is to big for 32 bit MySQL I need to install 64bit on the same system without touching the 32bit installation. However, when I try and install I keep getting conflicts between the 32 and 64 bit library and dependencies.

By: Mysql în paralel cu Percona | Tiberiu Contiu

Mysql în paralel cu Percona | Tiberiu Contiu — Tue, 05 Feb 2013 11:37:17 +0000

[…] https://shlomi-noach.github.io/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto […]

By: suryadilaga

suryadilaga — Tue, 16 Oct 2012 10:45:48 +0000

Hi shlomi,
I follow your step using mysql-init and work like a charm.
Thank you very much

By: shlomi

shlomi — Sat, 13 Oct 2012 07:12:37 +0000

@Suryadilaga, See this post: Recovering a MySQL `root` password: the fourth solution.

By: Suryadilaga

Suryadilaga — Sat, 13 Oct 2012 03:05:59 +0000

Hi
I have this multiple instance on my machine with 3 different port.
How do I reset root password on every port?
Thanks

By: shlomi

shlomi — Thu, 13 Sep 2012 05:18:39 +0000

Windows and Linux make for two completely different installation process. You CAN’T be “doing the same thing”.

I can’t presume to help you out by negotiating comments. Check out your MySQL error log is the one thing I can tell you.

Otherwise, best place to get advice is stackoverflow.com, or otherwise get consulting.

By: Hasee

Hasee — Thu, 13 Sep 2012 04:37:45 +0000

Iam doing the same thing in Windows successfully. But in linux, I face some difficulties. I follow your valuable suggestions, but Iam facing another problem:

Starting MySQL……………………………………………………………………………………….. ERROR! The server quit without updating PID file (/var/lib/mysql/Test.pid).

Why this happends???

By: shlomi

shlomi — Wed, 12 Sep 2012 17:21:49 +0000

@Hasee,

If you are beginner, then perhaps all the above post is not for you. Nevertheless, if you followed it, then you have installed MySQL somewhere. Let’s say its /usr/local/mysql55

In /etc/init.d/mysqldtest, set
basedir=/usr/local/mysql55

If you don’t manage the above I strongly recommend that you do not attempt a manual dual install of MySQL.

By: Hasee

Hasee — Wed, 12 Sep 2012 12:20:18 +0000

Could you please explain it??? Iam a beginner in mysql with linux