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 [at] 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 [at] deejaymail.it
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] 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 [at] 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 <JHN [at] 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 =3D C:/MySQL/data=5F11/
> port =3D 3306
> server-id =3D 1
> bind-address =3D 10.10.150.11
>
> my-20.cnf
> [mysqld]
> datadir =3D C:/MySQL/data=5F20/
> 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
>
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=3D"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
--=_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 [at] 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 [at] 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 <JHN [at] rtx.dk> 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 [at] 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 [at] 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
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 [at] 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 [at] 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 [at] 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 <JHN [at] rtx.dk> 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 [at] 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------
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Djhn [at] rtx.dk
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32 [at] m.gmane.org
