REstricting MySQL access to port 3306

2009-09-24 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: REstricting MySQL access to port 3306

2009-09-24 Thread John
: 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 Ici doc...@nl2k.ab.ca God

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 Willy
Subject: RE: REstricting MySQL access to port 3306 I don't think there's anything specific to MySQL but for any system you should ensure you have a good well configured firewall set up, make sure antivirus software is installed and kept up to date, ensure programs only run with essential

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 j...@butterflysystems.co.uk Sent: 24 September 2009 15:07 To: 'The Doctor' doc...@doctor.nl2k.ab.ca; mysql@lists.mysql.com Subject: RE: REstricting MySQL access to port 3306 I don't think there's anything

Re: REstricting MySQL access to port 3306

2009-09-24 Thread Johan De Meersman
my Sony Ericsson XPERIA™ X1. -Original Message- From: John j...@butterflysystems.co.uk Sent: 24 September 2009 15:07 To: 'The Doctor' doc...@doctor.nl2k.ab.ca; mysql@lists.mysql.com Subject: RE: REstricting MySQL access to port 3306 I don't think there's anything specific

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

2007-12-10 Thread Ananda Kumar
\MySQL\MySQL Server 4.1\binmysqld-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 [ERROR] Aborting 071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete Also

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

2007-12-09 Thread peri
[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\binmysqladmin

RE: secure port 3306

2007-05-07 Thread Steven Buehler
-A PREROUTING -t nat -p tcp -s client-ip \ -d linux-fw-ip --dport 3306 -j DNAT --to internal-ip: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

Re: secure port 3306

2007-05-07 Thread BJ Swope
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 SSH Tunnels. Source

RE: secure port 3306

2007-05-07 Thread Mogens Melander
-A PREROUTING -t nat -p tcp -s client-ip \ -d linux-fw-ip --dport 3306 -j DNAT --to internal-ip: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

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
-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 Buehler wrote: The thing is...I need to securely do

RE: secure port 3306

2007-05-04 Thread Steven Buehler
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

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

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

Re: secure port 3306

2007-05-02 Thread Mogens Melander
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 access. Another problem is that even if we do tunnel, it needs to go thru one

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: 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 INPUT -s 127.0.0.1 --dport 3306 -j ACCEPT

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 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? Thanks in advance. you are playing

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. URL: http://www.mysql.com/doc/G/R/GRANT.html -- Roger

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? I let

RE: Port 3306 restricted to IP addresses

2002-04-04 Thread adam nelson
- 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 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

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 command line to safe_mysqld

Re: Port 3306

2001-02-06 Thread btjones
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 have to use the server name "localhost" in you

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: [EMAIL PROTECTED] Subject: Re: Port 3306

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, Gus Constan

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 local (server side) access. Can

Re: Port 3306

2001-02-05 Thread Mikel King
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. Can someone point to docs or notes dealing with this issue

RE: Port 3306

2001-02-05 Thread johnny p.
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 firewall software (ipchains on linux, don't

Re: Port 3306

2001-02-05 Thread Eran Boudjnah
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 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 s