Date: Sun, 03 Jan 2010 13:44:26 +0000 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: jaymax <jaymax36@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: Possible mysql.sock problem | ERROR 2002 (HY000) Message-ID: <4B409F3A.80405@infracaninophile.co.uk> In-Reply-To: <27001411.post@talk.nabble.com>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --]
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)
copy that into ${mysql_dbdir}/my.cnf and edit to make any local
customizations.
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
Kent, CT11 9PW
[-- Attachment #2 --]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEAREIAAYFAktAnz8ACgkQ8Mjk52CukIy79QCeJpmVVAs2+sW5qZrRZD8vog3i
hCkAn00rStLkhiVzZkJQEP6CAosqwwrK
=T6a8
-----END PGP SIGNATURE-----
home |
help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4B409F3A.80405>