Possible mysql.sock problem | ERROR 2002 (HY000)

jaymax jaymax36 at gmail.com
Thu Jan 7 20:15:21 UTC 2010

Thanks !!!
Got it resolved after adding 
mysql_socket="/usr/tmp/mysql.sock" to the rc.conf file
Removing the /etc/my.cnf file as the aetting were redundant with those used
in the compilation
deinstalling and reinstalling both the server and the client

Matthew Seaman-2 wrote:
> jaymax wrote:
>> 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)
> There's a $mysql_socket rc.conf variable you need to set as well.
>> Settings in rc.conf
>> 	mysql_enable="YES"
>> 	mysql_limits="YES"
>> 	mysql_dbdir="/disk02/db/mysql/DATA"
>> 	mysql_args=""
>         mysql_socket="/usr/tmp/mysql.sock"
> (Although if /usr/tmp is set to mode 1777, what's the benefit of using
> that
> location rather than the default /tmp/mysql.sock ?)
> Initially they were on their own file systems both ran into problems of
> restricted sizes and overflow condition.
> Judging by the complaints about 'update log no longer supported' I'm
> guessing that there is somewhere a my.cnf or a .my.cnf file filled with
> configuration settings appropriate to a much earlier version of MySQL.
> A good strategy is to grab one of the sample .cnf files from
> /usr/local/share/mysql (according to the capabilities of your server)
> copy that into ${mysql_dbdir}/my.cnf and edit to make any local 
> customizations.
> Aparently  ignored after 

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

More information about the freebsd-questions mailing list