Multiple services on a single server.

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 =3D C:/MySQL/data_11/
port =3D 3306
server-id =3D 1
bind-address =3D 10.10.150.11

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

and installed them with the following commands
mysqld-nt.exe --install mysql-11 --defaults-file=3D"C:\MySQL\my-11.cnf"
mysqld-nt.exe --install mysql-20 --defaults-file=3D"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

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Multiple services on a single server.

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

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=s.dazzo@deejaymail.it


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Multiple services on a single server.

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 =3D C:/MySQL/data_11/
port =3D 3306
server-id =3D 1
bind-address =3D 10.10.150.11

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

and installed them with the following commands
mysqld-nt.exe --install mysql-11 --defaults-file=3D"C:\MySQL\my-11.cnf"
mysqld-nt.exe --install mysql-20 --defaults-file=3D"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

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Multiple services on a single server.

--=_alternative 00577627852570AE_=
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

Jesper H=F8rup wrote on 11/03/2005 10:06:37 AM:

> Not good enough... I need all the servicses to listen on the same=20
port(3306)
> I'll try to change the server ID, and observe what happens...
>=20
> /jesper
>=20
> --------------------
> change the port mumber and the server ID!
> sd
> --------------------
> Hi,
>=20
> I'm trying to install multiple MySQL servers on a single PC.
> The services must all listen on port 3306, and be accessible from=20
> local intranet(10.10.x.x)
>=20
> I have the following IP adresses:
> 10.10.150.11
> 10.10.150.20
>=20
> I have made two .cnf files
> my-11.cnf
> [mysqld]
> datadir =3D C:/MySQL/data=5F11/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.11
>=20
> my-20.cnf
> [mysqld]
> datadir =3D C:/MySQL/data=5F20/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.20
>=20
> and installed them with the following commands
> mysqld-nt.exe --install mysql-11 --defaults-file=3D"C:\MySQL\my-11.cnf"
> mysqld-nt.exe --install mysql-20 --defaults-file=3D"C:\MySQL\my-20.cnf"
>=20
> But it don't work, I always get:
> ERROR 1130: Host '10.10.150.11' is not allowed to connect to this MySQL=20
server
> when trying 'mysql -h 10.10.150.11 -u root'
>=20
> please help.
>=20
> Thanks in advance
> Jesper
>=20

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

NET STOP mysql-11

and restarting it manually with no privilege checking

mysqld-nt.exe --console mysql-11 --defaults-file=3D"C:\MySQL\my-11.cnf"=20
--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=20
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.=20

Please keep us informed of your outcome.

hth,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


--=_alternative 00577627852570AE_=--

Re: Multiple services on a single server.

The only problem I can think off is that you assigned different ips,
so, the default configuration of "root@localhost" is not working,
because the privileges table is blocking it.

Try running your server from the command line using --skip-grant-table
and set (using GRANT, check the manual for syntax) the user@host
configs that you'll allow, be sure to allow root from both your IP
addresses.

Try again and keep us informed.

On 11/3/05, Jesper H=F8rup wrote:
> Not good enough... I need all the servicses to listen on the same port(33=
06)
> 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 i=
ntranet(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 =3D C:/MySQL/data_11/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.11
>
> my-20.cnf
> [mysqld]
> datadir =3D C:/MySQL/data_20/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.20
>
> and installed them with the following commands
> mysqld-nt.exe --install mysql-11 --defaults-file=3D"C:\MySQL\my-11.cnf"
> mysqld-nt.exe --install mysql-20 --defaults-file=3D"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 s=
erver
> when trying 'mysql -h 10.10.150.11 -u root'
>
> please help.
>
> Thanks in advance
> Jesper
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Multiple services on a single server.

Daniel, You are my rescue!

It was in fact the default configuration that blocked the access.

Now I can run multiple MySQL services on ONE PC, all using port 3306, =
each listening on a specific IP.(IP's that is assigned to the NIC)

One word of caution:
Shawn, you sent me an example of how to start mysqld in the console.
mysqld-nt.exe --console mysql-11 --defaults-file=3D"C:\MySQL\my-11.cnf" =
--skip-grant-tables=20

The '--defaults-file=3D' MUST be the first argument after mysqld*.exe =
othervise it won't work.


Thanks,
Jesper

-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
Sent: 3. november 2005 17:05
To: MySQL Win32 List
Subject: Re: Multiple services on a single server.


The only problem I can think off is that you assigned different ips,
so, the default configuration of "root@localhost" is not working,
because the privileges table is blocking it.

Try running your server from the command line using --skip-grant-table
and set (using GRANT, check the manual for syntax) the user@host
configs that you'll allow, be sure to allow root from both your IP
addresses.

Try again and keep us informed.

On 11/3/05, Jesper H=F8rup wrote:
> 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 =3D C:/MySQL/data_11/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.11
>
> my-20.cnf
> [mysqld]
> datadir =3D C:/MySQL/data_20/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.20
>
> and installed them with the following commands
> mysqld-nt.exe --install mysql-11 =
--defaults-file=3D"C:\MySQL\my-11.cnf"
> mysqld-nt.exe --install mysql-20 =
--defaults-file=3D"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
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Djhn@rtx.dk


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org