MYSQL connection problem

mario.lobo at ipad.com.br mario.lobo at ipad.com.br
Tue Nov 30 05:57:11 PST 2004


Hi Guys;

As always, if this list is not the right place, please forgive me. 

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
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
9
5.0.0-alpha}l'zRjBG,!js%Zxl6f"p3
(after a few seconds...)
Connection closed by foreign host.

---------------------------------------------

>mysql -u root -P 5006 -h 127.0.0.1 -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.

mysql>

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

]>telnet localhost 5007
Trying ::1...
Trying 127.0.0.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 127.0.0.1 -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server during query

**************

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 
was.

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

thanks,

-- 
   //|  //||
  // | // ||
-//--//---|| ARIO LOBO
//  //    ||
---------------------------------
mario.lobo at ipad.com.br
http://www.ipad.com.br



More information about the freebsd-hackers mailing list