http://diymacserver.com/forum/ DIYMacServer » Topic: Mysql port listed as "0" ? en Wed, 08 Feb 2012 07:39:12 +0000 http://diymacserver.com/forum/topic/mysql-port-listed-as-0#post-609 Wed, 31 Dec 2008 09:35:30 +0000 Richard 609@http://diymacserver.com/forum/ <p>If you did follow the security guidelines with skip-networking the port won't work. The safest solution to connect is using the socket option for all connections. This works with dspam and sqlgrey as I set it up myself. However this is still a stange error.</p> <p>To make sure your my.cnf is used, make some changes that you would note there and restart mysql to see if the changes are reflected in the running mysql.</p> <p>I found several times that errors where related to mysql server not running while I thought it was. </p> http://diymacserver.com/forum/topic/mysql-port-listed-as-0#post-606 Sun, 28 Dec 2008 00:24:53 +0000 dw 606@http://diymacserver.com/forum/ <p>Hi all,</p> <p>Still trying to get everything up and running on Leopard. Resolved at least 1 strange issue which I'll report on after I make sure everything works. </p> <p>I am continuing to have a problem with tools like dspam and sqlgrey connecting to mysql. With a lot of retrying and searching, the one thing I've come across that seems strange is that when I enter mysql_config, it tells me the following:</p> <p><code><br /> --cflags [-I/usr/local/mysql/include/mysql -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT]<br /> --include [-I/usr/local/mysql/include/mysql]<br /> --libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm]<br /> --libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lz -lm]<br /> --socket [/tmp/mysql.sock]<br /> --port [0]<br /> --version [5.0.67]<br /> --libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lz -lm]<br /> </code></p> <p>What's strange is that the port is listed as 0, although in my.cnf the port is declared as 3306.</p> <p>I'll keep googling, but if anyone has an idea, please let me know.</p> <p>Dave </p>