Can you try switching the port to another port number? Perhaps a lower port number?
See if you can get it to connect in that way?
In your log file, does it print messages about having successfully started up?
Do you have ipfw or any other packet filter on your machine?
----- Original Message ----- From: <[EMAIL PROTECTED]>
To: "Arun Pereira" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 30, 2004 12:24 PM
Subject: Re: MYSQL connection problem (correction re-post)
Sorry for this :( . Correction marked with " <=====**** "
I typed a my.cnf from another machine. only the port differs.
==============
Yeah, it is the only one on that port. The worst part is that the connection attempt doesn´t even
generates a log entry !! I looked into the log also !!
netstat -an | grep LIST tcp4 0 0 *.5007 *.* LISTEN tcp4 0 0 *.199 *.* LISTEN tcp4 0 0 *.443 *.* LISTEN tcp4 0 0 *.80 *.* LISTEN tcp4 0 0 127.0.0.1.25 *.* LISTEN tcp4 0 0 *.22 *.* LISTEN
here is my.cnf
[mysqld] datadir=/bd/mysql/data socket=/home/xxxxxxx/mysql/mysql.sock
port=5007 <=====****
set-variable = max_connections=2000
[mysql.server] user=xxxxxxx basedir=/bd/
[safe_mysqld] err-log=/home/xxxxxxx/mysql/mysqld.log pid-file=/home/xxxxxxx/mysql/mysqld.pid
I know this might sound rather obvious but have you checked whether mysql is
actually listening on that port? Perhaps that port is being used by another
daemon or process and mysql cannot bind to it while starting.
use netstat to check this. Also try and look at the error log file for the
mysql daemon. Usually this is located in the /var/db/mysql directory.
-- //| //|| // | // || -//--//---|| ARIO LOBO // // || --------------------------------- [EMAIL PROTECTED] http://www.ipad.com.br
_______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-hackers To unsubscribe, send any mail to "[EMAIL PROTECTED]"
_______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-hackers To unsubscribe, send any mail to "[EMAIL PROTECTED]"
