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
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 permissions and keep your system up to date with all the late

Re: restricting mysql

2002-11-15 Thread Michael T. Babcock
David Lubowa wrote: i thought the main reason was that he did not want to use a firewall ( for some reason , only he knows why :) ) As someone who enables full iptables firewalling on every Linux machine on my networks, I never see 'not using a firewall' as plausible, even if I'm told its t

RE: restricting mysql

2002-11-15 Thread David Lubowa
] Sent: Friday, November 15, 2002 7:45 PM To: Joseph Bueno Cc: [EMAIL PROTECTED]; Admin-Stress; [EMAIL PROTECTED] Subject: Re: restricting mysql Joseph Bueno wrote: >You can also restrict port 3306 to localhost with : >bind-address = 127.0.0.1 >in /etc/my.cnf > > Or even: iptab

Re: restricting mysql

2002-11-15 Thread Joseph Bueno
You can also restrict port 3306 to localhost with : bind-address = 127.0.0.1 in /etc/my.cnf Hope this helps -- Joseph Bueno David Lubowa wrote: > port 3306 is the default port for mysql , if you do "grep -i 3306 > /etc/services " you will see what service runs on that port. As for > restricting

RE: restricting mysql

2002-11-15 Thread David Lubowa
port 3306 is the default port for mysql , if you do "grep -i 3306 /etc/services " you will see what service runs on that port. As for restricting access to it without a firewall i guess you would have to set up specific users who can access it and throw out the rest. Have a look at the mysql docs

Re: restricting mysql

2002-11-15 Thread Lars Andersson
On Fri, 15 Nov 2002, Admin-Stress wrote: > I tried --skip-networking, but then mysqld could not be started. I got this from >google.com. Is it > the correct way? It's correct. Put this in your /etc/my.cnf and restart mysql. [mysqld] skip-networking /Lars ---