MYSQL connection problem

mario.lobo at mario.lobo at
Wed Dec 1 03:20:25 PST 2004

Hello Everyone;

I have two machines:

1) Free 4.10 / mysql (5.0.0) listening on port 5006

2) Free 5.3 Release / mysql (5.0.0) listening on port 5007

On both, no firewalls, blocks or anything of that sort. Both machines have the same configuration.
Both mysql were compiled from the ports with the same options. The only difference between the two 
machines is the Free version and port mysql is listening on.

Here are the outputs of the following commands on machine 1):

>telnet localhost 5006
Connected to localhost.
Escape character is '^]'.
(after a few seconds...)
Connection closed by foreign host.


>mysql -u root -P 5006 -h -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.0-alpha

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


Now, here are the outputs of the same commands on machine 2):

]>telnet localhost 5007
Trying ::1...
Connected to localhost.
Escape character is '^]'.
Connection closed by foreign host. (no wait for this line to show!)

>mysql -u root -P 5007 -h -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server during query
(no wait for the above line to show either!)


I can only connect on machine 2) if I use a mysql.sock file. Any attempt to connect via TCP/IP 
doesn´t work !! command line client, java connectors (all possible versions) none work.

I´ve been into every single link google returned to me on the ERROR 2013 above for 2 days now and 
none of them had any info to get this working. Believe me, I tried every hint of suggestion there 

I really hope someone here has any clues to what is going on.

I´ve posted this to hackers but no clues so far.


   //|  //||
  // | // ||
-//--//---|| ARIO LOBO
//  //    ||
mario.lobo at

More information about the freebsd-questions mailing list