Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
ERROR 2013: Lost connection to MySQL server during query
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
dnamroud
Guru
Guru


Joined: 01 Jun 2005
Posts: 346
Location: Canada

PostPosted: Thu Aug 17, 2006 6:44 pm    Post subject: ERROR 2013: Lost connection to MySQL server during query Reply with quote

Hello

I am trying to login thrun my mysql, when i use the 127.0.0.1, I got the following message
Quote:

test mysql # mysql -u mona -h 127.0.0.1 -p
Enter password:
ERROR 2013: Lost connection to MySQL server during query


However if i use localhost or system's IP or from outside i am able to login...
Quote:

test mysql # mysql -u mona -h localhost -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.0.25

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye


more info:
Quote:


test mysql # ping 127.0.0.1
PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.031 ms
64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.011 ms
64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.009 ms
64 bytes from 127.0.0.1: icmp_seq=4 ttl=64 time=0.009 ms

test mysql # ifconfig lo
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:551 errors:0 dropped:0 overruns:0 frame:0
TX packets:551 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:31493 (30.7 Kb) TX bytes:31493 (30.7 Kb)



Why i am getting this error...
Thank you
Dany
Back to top
View user's profile Send private message
qriff
n00b
n00b


Joined: 04 Dec 2003
Posts: 73

PostPosted: Thu Feb 01, 2007 5:20 pm    Post subject: Reply with quote

Same solution solves the re-login problem with mod_auth_mysql...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum