mysql over TCP and far out PIDs

Jamon Camisso jamon.camisso-H217xnMUJC0sA/PxXw9srA at public.gmane.org
Wed Feb 19 18:30:38 UTC 2014


On 19/02/14 12:08 PM, Darryl Moore wrote:
> Hi list,
> 
> I lurk around this maillist a lot, but don't say much. I'm having an
> interesting issue right now though that maybe someone here might have
> some insight into, which I'd really appreaciate.
> 
> I'm running servers with Ubuntu 12.04 with upgraded 3.5 kernels and
> mysql 5.5.35
> 
> On three machines which are supposedly identical, only one works as it
> is suppose to allowing me to login to mysql via TCP. On the other two I
> get this message.
> 
> Lost connection to MySQL server at 'reading initial communication
> packet', system error: 0
> 
> I know mysql is listening (or someone is) because on a non listening
> port I get:
> 
> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
> 
> Mysql is configured identical on all machines. What is really odd is
> when I run netstat I get the follow output:
> 
> #netstat -n -l -e | grep tcp
> tcp 0 0 0.0.0.0:10050 0.0.0.0:* LISTEN 128 15430
> tcp 0 0 0.0.0.0:5222 0.0.0.0:* LISTEN 120 14278
> tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 116 452074
> tcp 0 0 127.0.0.1:587 0.0.0.0:* LISTEN 0 15278

Set bind_address to 127.0.0.1 if you want connections locally. It is
never a good idea to let mysql listen on 0.0.0.0, since it will bind to
all available interfaces and possibly expose your data.

A side effect if setting the bind_address will be consistency across all
three of your machines, and you will be able to then isolate the problem
with logins.

I'll hazard a guess and say you don't have explicit grants for your user
at 127.0.0.1.

Cheers, Jamon
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists





More information about the Legacy mailing list