mysql.sock

[drewsheneman]

I installed mysql through ports on freebsd 6.1. i started the daemon, and mysql starts. however when i try "mysql" i get

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

i looked this up on the mysql page and did find much help. first i tried

shell> chmod +t /tmp

to protect tmp. that didnt solve it, so i tried to point my sock file to another directory in /etc/my.cnf:

[mysqld]
socket=/usr/local/etc

[client]
socket=/usr/local/etc

i got the same error message:

# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/etc' (38)
#

even with the new directory.

i tried mysqld_safe:

# mysqld_safe
Starting mysqld daemon with databases from /var/db/mysql
rm: /usr/local/etc: is a directory
STOPPING server from pid file /var/db/mysql/hostname.com.pid
070312 10:39:46 mysqld ended

does anyone know where my problem lies? thanks!