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