MYSQL connection problem
mario.lobo_at_ipad.com.br
Date: 12/01/04
- Previous message: Peter Risdon: "Re: ServRAID 5i and DLT"
- Next in thread: Daniel Bye: "Re: MYSQL connection problem"
- Reply: Daniel Bye: "Re: MYSQL connection problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: freebsd-database@freebsd.org Date: Wed, 01 Dec 2004 08:23:51 -0300
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
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 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.
I´ve posted this to hackers but no clues so far.
thanks,
-- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- mario.lobo@ipad.com.br http://www.ipad.com.br _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
- Previous message: Peter Risdon: "Re: ServRAID 5i and DLT"
- Next in thread: Daniel Bye: "Re: MYSQL connection problem"
- Reply: Daniel Bye: "Re: MYSQL connection problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
