At 9:09 +1200 9/3/02, Defryn, Guy wrote:
>I have installed mysql from the ports collection on FreeBSD and it
>was working fine.
>
>I would like to move the /tmp/mysql.sock file ( or is it safe to
>leave it there?) so I
>Created a my.cnf file with the following options
>[mysqld]
>port=3306
>socket=/usr/local/mysql/mysql.sock
>
>I take down the mysql server and restart but it refuses to work. It
>is still looking in the /tmp directory
1) *where* did you create the my.cnf file?
2) Do you mean that the server still creates the file in /tmp, or that it
creates it where you specified, but that *clients* still look in /tmp?
If the latter, remember that you need to tell the clients where to find
the file as well:
[client]
socket=/usr/local/mysql/mysql.sock
>
>What am I doing wrong? Could this be a permission thing on the sock file?
>What permissions does this file need?
>
>Cheers
>
>Guy
