Re: REstricting MySQL access to port 3306

2009-09-24 Thread Johan De Meersman
by firewall . > > > > > > Willy > > Sent from my Sony Ericsson XPERIA™ X1. > > > > -Original Message- > > From: John > > Sent: 24 September 2009 15:07 > > To: 'The Doctor' ; mysql@lists.mysql.com > > Subject: RE: REstricting

Re: REstricting MySQL access to port 3306

2009-09-24 Thread Claudio Nanni
> > Willy > Sent from my Sony Ericsson XPERIA™ X1. > > -Original Message- > From: John > Sent: 24 September 2009 15:07 > To: 'The Doctor' ; mysql@lists.mysql.com > Subject: RE: REstricting MySQL access to port 3306 > > I don't think there

RE: REstricting MySQL access to port 3306

2009-09-24 Thread Willy
Limit connection from trusted host will reduce it. And its better handled by firewall . Willy Sent from my Sony Ericsson XPERIA™ X1. -Original Message- From: John Sent: 24 September 2009 15:07 To: 'The Doctor' ; mysql@lists.mysql.com Subject: RE: REstricting MySQL access to

Re: REstricting MySQL access to port 3306

2009-09-24 Thread muhammad subair
If just view people can access MySQL in port 3306 you can set in firewall to not accessible from all host except the host which you list. If very wide people need the MySQL, like in hosting provider, I think you can use application which make people can manage MySQL via server such as PHPMyAdmin

RE: REstricting MySQL access to port 3306

2009-09-24 Thread John
@lists.mysql.com Subject: REstricting MySQL access to port 3306 Some months a back I had to firewall port 3306 due to DDoS. I cannot do this now as a client needs 3306 outside the LAN. What can I do to prevent DDoS on my MySQL server? -- Member - Liberal International This is doc...@nl2k.ab.ca I

REstricting MySQL access to port 3306

2009-09-23 Thread The Doctor
Some months a back I had to firewall port 3306 due to DDoS. I cannot do this now as a client needs 3306 outside the LAN. What can I do to prevent DDoS on my MySQL server? -- Member - Liberal International This is doc...@nl2k.ab.ca Ici doc...@nl2k.ab.ca God, Queen and country! Beware Anti

Re: MySQL give me the following error:Do you already have another mysqld server running on port: 3306 ?

2007-12-10 Thread Ananda Kumar
g error : > > C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld-max-nt --standalone > Can't start server: Bind on TCP/IP port: Invalid argument > 071207 22:50:57 [ERROR] Do you already have another mysqld server running > on > port: 3306 ? > 071207 22:50:57 [ERR

MySQL give me the following error:Do you already have another mysqld server running on port: 3306 ?

2007-12-09 Thread peri
22:50:57 [ERROR] Do you already have another mysqld server running on port: 3306 ? 071207 22:50:57 [ERROR] Aborting 071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete Also when I try to run mysqladmin shutdown command it gives me the following error C:\Program Files\MySQL\MySQL Server 4.1\bin>

RE: secure port 3306

2007-05-07 Thread Mogens Melander
and > Server-2. > Steve > > > -Original Message- > From: Mogens Melander [mailto:[EMAIL PROTECTED] > Sent: Monday, May 07, 2007 1:35 PM > To: Steven Buehler > Cc: mysql@lists.mysql.com > Subject: RE: secure port 3306 > > > On Mon, May 7, 2007 17:40, Steven

RE: secure port 3306

2007-05-07 Thread Steven Buehler
But I also need to make sure that nobody is sniffing between Server-1 and Server-2. Steve -Original Message- From: Mogens Melander [mailto:[EMAIL PROTECTED] Sent: Monday, May 07, 2007 1:35 PM To: Steven Buehler Cc: mysql@lists.mysql.com Subject: RE: secure port 3306 On Mon, May 7

RE: secure port 3306

2007-05-07 Thread Mogens Melander
-A FORWARD -i $EXTIF -p tcp -s --dport 3306 -j ACCEPT > iptables -A PREROUTING -t nat -p tcp -s \ >-d --dport 3306 -j DNAT --to :3306 > > On Wed, May 2, 2007 17:03, Steven Buehler wrote: >> I have a client that needs to be able to remotely connect to port 3306 >>

Re: secure port 3306

2007-05-07 Thread BJ Swope
IL PROTECTED] now you can point your sql client to localhost 3306 and it will then be transported across your ssh session to server1. Once it gets to server1 then server1 will forward that traffic to server2 on port 3306. putty, a well known windows based ssh client can do this under Connection >

RE: secure port 3306

2007-05-07 Thread Steven Buehler
ING -t nat -p tcp -s \ -d --dport 3306 -j DNAT --to :3306 On Wed, May 2, 2007 17:03, Steven Buehler wrote: > I have a client that needs to be able to remotely connect to port 3306 > securely. I have tried to suggest an SSH Tunnel, but they do not want > their clients to have SSH a

RE: secure port 3306

2007-05-04 Thread Steven Buehler
ely connect to port 3306 > securely. I have tried to suggest an SSH Tunnel, but they do not want > their > clients to have SSH access. Another problem is that even if we do tunnel, > it needs to go thru one server that is connected to the Internet and into > the MySQL server which

Re: secure port 3306

2007-05-02 Thread Mogens Melander
Buehler wrote: > I have a client that needs to be able to remotely connect to port 3306 > securely. I have tried to suggest an SSH Tunnel, but they do not want > their > clients to have SSH access. Another problem is that even if we do tunnel, > it needs to go thru one server that is c

RE: secure port 3306

2007-05-02 Thread Jay Blanchard
[snip] I have a client that needs to be able to remotely connect to port 3306 securely. I have tried to suggest an SSH Tunnel, but they do not want their clients to have SSH access. Another problem is that even if we do tunnel, it needs to go thru one server that is connected to the Internet and

secure port 3306

2007-05-02 Thread Steven Buehler
I have a client that needs to be able to remotely connect to port 3306 securely. I have tried to suggest an SSH Tunnel, but they do not want their clients to have SSH access. Another problem is that even if we do tunnel, it needs to go thru one server that is connected to the Internet and into

RE: restricting port 3306 connections to localhost

2002-11-15 Thread Tom Morgan
, 2002 10:47 AM To: '[EMAIL PROTECTED]' Subject: Re: restricting port 3306 connections to localhost Joseph Bueno wrote something about SQL: >>You can also restrict port 3306 to localhost with : >>bind-address = 127.0.0.1 >>in /etc/my.cnf > Or even: iptables -A INP

Re: restricting port 3306 connections to localhost

2002-11-15 Thread Michael T. Babcock
Joseph Bueno wrote something about SQL: You can also restrict port 3306 to localhost with : bind-address = 127.0.0.1 in /etc/my.cnf Or even: iptables -A INPUT -s 127.0.0.1 --dport 3306 -j ACCEPT iptables -A INPUT --dport 3306 -j DROP -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 21:24 adam nelson wrote: > Firewall isn't good enough (who else is inside your firewall, likely the > entire hosting company or internal corporate network). The user table > has a host column that I use. Also, you can en

RE: Port 3306 restricted to IP addresses

2002-04-04 Thread adam nelson
ssage- From: Michael Zimmermann [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:34 AM To: Tshering Norbu; [EMAIL PROTECTED] Subject: Re: Port 3306 restricted to IP addresses -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 12:23 Tshering Norbu wrote: >

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 12:23 Tshering Norbu wrote: > For the inbound connection on port 3306 of MySQL Server, how do I restrict > the connection to some IP addresses something like 1.2.3.* > > What do I need to do in my.cnf file

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Egor Egorov
Tshering, Thursday, April 04, 2002, 1:23:09 PM, you wrote: TN> For the inbound connection on port 3306 of MySQL Server, how do I restrict TN> the connection to some IP addresses something like 1.2.3.* TN> What do I need to do in my.cnf file? Nothing. You should use 'host'

RE: Port 3306 restricted to IP addresses

2002-04-04 Thread Roger Baklund
* Tshering Norbu > For the inbound connection on port 3306 of MySQL Server, how do I restrict > the connection to some IP addresses something like 1.2.3.* > > What do I need to do in my.cnf file? Nothing, this is done from the client. http://www.mysql.com/doc/G/R/GRANT.html

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Dicky Wahyu Purnomo
On Thu, 4 Apr 2002 16:23:09 +0600 "Tshering Norbu" <[EMAIL PROTECTED]> wrote: > For the inbound connection on port 3306 of MySQL Server, how do I restrict > the connection to some IP addresses something like 1.2.3.* > > What do I need to do in my.cnf file? >

Port 3306 restricted to IP addresses

2002-04-04 Thread Tshering Norbu
For the inbound connection on port 3306 of MySQL Server, how do I restrict the connection to some IP addresses something like 1.2.3.* What do I need to do in my.cnf file? Thanks in advance. NOBBY - Before posting, please

Re: Port 3306

2001-02-06 Thread Eran Boudjnah
Yes, sockets are much faster. Best regards, -Eran "William R. Mussatto" wrote: > On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: > > > Date: Mon, 5 Feb 2001 13:11:51 -0800 > > From: [EMAIL PROTECTED] > > To: Gus Constan <[EMAIL PROTECTED]> > > Cc

Re: Port 3306

2001-02-06 Thread btjones
> From: [EMAIL PROTECTED] > To: Gus Constan <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Port 3306 > > > Add --skip-networking to your my.cnf file or pass it on the command line to > safe_mysqld. This will stop ALL TCP connections to mySQL, so you'll h

Re: Port 3306

2001-02-06 Thread William R. Mussatto
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: > Date: Mon, 5 Feb 2001 13:11:51 -0800 > From: [EMAIL PROTECTED] > To: Gus Constan <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Port 3306 > > > Add --skip-networking to your my.cnf file or pass it on the

Re: Port 3306

2001-02-05 Thread Eran Boudjnah
ROTECTED]] > > Sent: Monday, February 05, 2001 2:46 PM > > To: Gus Constan > > Cc: [EMAIL PROTECTED] > > Subject: Re: Port 3306 > > > > > > What OS?  If Linux or *BSD, they have firewall software > > (ipchains on linux, > > don't recall what

Re: Port 3306

2001-02-05 Thread btjones
hreads, this is not an option. "Gus Constan" <[EMAIL PROTECTED]> wrote: I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point

RE: Port 3306

2001-02-05 Thread johnny p.
ffect your system... johnny p. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 2:46 PM > To: Gus Constan > Cc: [EMAIL PROTECTED] > Subject: Re: Port 3306 > > > What OS? If Linux or *BSD, they have firewa

Re: Port 3306

2001-02-05 Thread Mikel King
;t recall what it is on BSD) > > > I'm new to MySQL, this may be a simple question; > > > > How do I turn off listen on port 3306?, I don't want to serve MySQL on the > > net, I only need it for local > > (server side) access. >

Re: Port 3306

2001-02-05 Thread Kevin . Brown
What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) > I'm new to MySQL, this may be a simple question; > > How do I turn off listen on port 3306?, I don't want to serve MySQL on the > net, I only need it for l

Port 3306

2001-02-05 Thread Gus Constan
I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. thanks, G