I have a replicated MySQL environments were the master db gets a continuous "Aborted_connects". How can I find out what IP and what user are causing the aborted connections. There are about 500 connections created by 25 applications. I only have access to the database servers.
migrated from stackoverflow.com Dec 10 '10 at 19:56
This question came from our site for professional and enthusiast programmers.
Moreover, here is a great blog post which I've used many times to track down the bad connection attempts using tcpdumps.