R: R: R: Multiple instances howto

2008-04-01 Thread Nanni Claudio
] 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

R: R: Multiple instances howto

2008-03-31 Thread Nanni Claudio
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

Re: R: R: Multiple instances howto

2008-03-31 Thread toutiao
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

Re: R: R: Multiple instances howto

2008-03-31 Thread toutiao
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