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


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to