List:MySQL on Win32« Previous MessageNext Message »
From:Jesper Hørup Date:November 3 2005 11:39am
Subject:Multiple services on a single server.
View as plain text  
Hi,

I'm trying to install multiple MySQL servers on a single PC.
The services must all listen on port 3306, and be accessible from local
intranet(10.10.x.x)

I have the following IP adresses:
	10.10.150.11
	10.10.150.20

I have made two .cnf files
my-11.cnf
	[mysqld]
	datadir         = C:/MySQL/data_11/
	port            = 3306
	server-id       = 1
	bind-address    = 10.10.150.11

my-20.cnf
	[mysqld]
	datadir         = C:/MySQL/data_20/
	port            = 3306
	server-id       = 1
	bind-address    = 10.10.150.20

and installed them with the following commands
mysqld-nt.exe --install mysql-11 --defaults-file="C:\MySQL\my-11.cnf"
mysqld-nt.exe --install mysql-20 --defaults-file="C:\MySQL\my-20.cnf"

But it don't work, I always get:
ERROR 1130: Host '10.10.150.11' is not allowed to connect to this MySQL server
when trying 'mysql -h 10.10.150.11 -u root'

please help.

Thanks in advance
Jesper
Thread
Multiple services on a single server.Jesper Hørup3 Nov
  • Re: Multiple services on a single server.SD3 Nov
RE: Multiple services on a single server.Jesper Hørup3 Nov
  • RE: Multiple services on a single server.SGreen3 Nov
  • Re: Multiple services on a single server.Daniel da Veiga3 Nov
RE: Multiple services on a single server.Jesper Hørup4 Nov