[BlueOnyx:03629] Re: Tips for tracking down rogue mysql connection use?

[Jeff Jones]

Yes, sorry, should have mentioned that this is an 'all in one'  
dedicated box running LAMP - with no external ports but 80, 443 open  
to the Internet. MySQL only accepts connections from localhost.

Thankfully each website on this server has it's own dbuser account so  
looking for which user has loads of connections will really help!

Thanks for the tips!

Jeff

Sent from my iPhone

On 19 Feb 2010, at 06:02, Michael Stauber <mstauber at blueonyx.it> wrote:

> Hi Chris,
>
>> There's really no reason to be
>> allowing remote MySQL connections to the public at-large.
>
> Indeed. My typical firewall also closes down port 3306 to prevent  
> remote MySQL
> connections. And if need be, exceptions can be made for hosts that  
> require
> remote access.
>
> -- 
> With best regards
>
> Michael Stauber
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx