Date: Sun, 3 Jan 2010 05:10:37 -0800 (PST) From: jaymax <jaymax36@gmail.com> To: freebsd-questions@freebsd.org Subject: Possible mysql.sock problem | ERROR 2002 (HY000) Message-ID: <27001411.post@talk.nabble.com>
next in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?27001411.post>