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