]
Inviato: martedì 1 aprile 2008 2.10
A: mysql@lists.mysql.com
Oggetto: Re: R: R: Multiple instances howto
Nanni,
To make things even creepier, I tried to access the 2 alleged instances
from a different WinXP PC by starting 2 instances of MySQL Administrator,
using different port number 33061 and 33062
Jing,
First: you can have only ONE mysql instance running for each installation,
but you can have as many installations as you want on each server.
So to answer your statement only the first command started mysql,
while the second command should have given you an error(there is already an
Nanni,
You know, it's really strange. On 2 different terminals, I ran
[EMAIL PROTECTED] etc]mysql -S /var/lib/mysql/mysql.sock -u root -p
AND
[EMAIL PROTECTED] etc]mysql -S /var/lib/mysql/mysql2.sock -u root -p
I was able to log in. Then I run show variables, I could actually see them
Nanni,
To make things even creepier, I tried to access the 2 alleged instances
from a different WinXP PC by starting 2 instances of MySQL Administrator,
using different port number 33061 and 33062 at the same time. And it worked!
I went further to create a database on each instances of MySQL