Possible mysql.sock problem | ERROR 2002 (HY000)

[jaymax]

 HELP! NEEDED URGENTLY

7.2-RELEASE #0: Fri May 1 08:49:13 UTC 2009
installed /usr/ports/databases/mysql54-server from ports

Installation seemed to go to completion - OK
but 
# /usr/local/bin/mysql_install_db - ERRORS listed as ==>
Installing MySQL system tables...
091230 13:35:02 [ERROR] The update log is no longer supported by MySQL in
version 5.0 and above. It is replaced by the binary log.
091230 13:35:02 [Note] Falcon: unable to open system data files.
091230 13:35:02 [Note] Falcon: creating new system data files.
091230 13:35:03 [Warning] Forcing shutdown of 2 plugins
OK
Filling help tables...
091230 13:35:04 [ERROR] The update log is no longer supported by MySQL in
version 5.0 and above. It is replaced by the binary log.
091230 13:35:05 [Warning] Forcing shutdown of 2 plugins
OK

Then running /usr/local/bin/mysqld_safe & ==>
091230 17:45:16 mysqld_safe Logging to
'/disk02/db/mysql/DATA/ax.lall.com.err'.
091230 17:45:16 mysqld_safe Starting mysqld daemon with databases from
/disk02/db/mysql/DATA
091230 17:45:16 mysqld_safe mysqld from pid file
/disk02/db/mysql/DATA/ax.lall.com.pid ended

Direct start from script /usr/local/etc/rc.d/mysql-server start fails also

And running /usr/local/bin/mysql ==>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/usr/tmp/mysql.sock' (2)


Tried various strategies for mysql.sock problems as suggested in thre forum
but can't seem to get any to work, if someone has any ideas they will be
much appreciated.

Thanks!

PS:
Settings in rc.conf
	mysql_enable="YES"
	mysql_limits="YES"
	mysql_dbdir="/disk02/db/mysql/DATA"
	mysql_args=""

In my.cnf file
	[client] 
	socket=/usr/tmp/mysql.sock
	[mysqld] 
	socket=/usr/tmp/mysql.sock

/usr/tmp permissions set to drwxrwxrwt

datadir = mysql:mysql ownership

HELP! NEEDED URGENTLY

-- 
View this message in context: http://old.nabble.com/Possible-mysql.sock-problem-%7C-ERROR-2002-%28HY000%29-tp27001411p27001411.html
Sent from the freebsd-questions mailing list archive at Nabble.com.