6 messages in com.mysql.lists.win32RE: Multiple services on a single ser...
FromSent OnAttachments
Jesper Hørup03 Nov 2005 03:39 
SD03 Nov 2005 03:46 
Jesper Hørup03 Nov 2005 07:06 
SGr...@unimin.com03 Nov 2005 07:55 
Daniel da Veiga03 Nov 2005 08:04 
Jesper Hørup04 Nov 2005 04:46 
Subject:RE: Multiple services on a single server.
From:SGr...@unimin.com (SGr@unimin.com)
Date:11/03/2005 07:55:13 AM
List:com.mysql.lists.win32

Jesper Hørup <JH@rtx.dk> wrote on 11/03/2005 10:06:37 AM:

Not good enough... I need all the servicses to listen on the same port(3306) I'll try to change the server ID, and observe what happens...

/jesper

-------------------- change the port mumber and the server ID! sd

-------------------- 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

I don't think is the server-id that's breaking access, I think it's your privileges; conflicting server-id's break replication. Try stopping the service

NET STOP mysql-11

and restarting it manually with no privilege checking

mysqld-nt.exe --console mysql-11 --defaults-file="C:\MySQL\my-11.cnf" --skip-grant-tables

try to connect from any other window or computer. If you are still denied, post that message. If not, use your session to create the appropriate users for that server, shutdown the console and restart the service.

mysqladmin -h 10.10.150.11 shutdown net start mysql-11

Now you can try to reconnect to .11 using the same account you tested with before.

Please keep us informed of your outcome.

hth, Shawn Green Database Administrator Unimin Corporation - Spruce Pine