MYSQL connection problem (correction re-post)
mario.lobo at ipad.com.br
mario.lobo at ipad.com.br
Tue Nov 30 09:20:58 PST 2004
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
// // ||
---------------------------------
mario.lobo at ipad.com.br
http://www.ipad.com.br
More information about the freebsd-hackers
mailing list