Re: Possible mysql.sock problem | ERROR 2002 (HY000)

[Matthew Seaman]

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 ?)

In my.cnf file

[client] socket=/usr/tmp/mysql.sock [mysqld] socket=/usr/tmp/mysql.sock

Is this the only my.cnf file on the system?  There are several places
where MySQL will pick up a my.cnf file: directly from the mysql_dbdir
or /usr/local/etc/my.cnf [The rc.d/mysql-server script automatically
adds ${mysql_dbdir}/my.cnf to the list of locations]

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)


        Cheers,


--
Dr Matthew J Seaman MA, D.Phil.                   7 Priory Courtyard
                                                 Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey     Ramsgate
                                                 Kent, CT11 9PW

copy that into ${mysql_dbdir}/my.cnf and edit to make any local customizations. Matthew

signature.asc
Description: OpenPGP digital signature