Date: Wed, 01 Dec 2004 08:23:51 -0300 From: mario.lobo@ipad.com.br To: freebsd-database@freebsd.org Cc: freebsd-questions@freebsd.org Subject: MYSQL connection problem Message-ID: <41AD7F97.13526.2896C2@localhost>
next in thread | raw e-mail | index | archive | help
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 di= fference 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 (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 t= o connect via TCP/IP doesn=B4t work !! command line client, java connectors (all possible versi= ons) none work. I=B4ve 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 h= int of suggestion there was. I really hope someone here has any clues to what is going on. I=B4ve posted this to hackers but no clues so far. thanks, -- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- mario.lobo@ipad.com.br http://www.ipad.com.br
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41AD7F97.13526.2896C2>