MySQL socket error

Toptyg

Verified User
Joined
May 25, 2007
Messages
22
Hello all
Can't connect to local MySQL server through socket '/tmp/mysql.sock'

cat my.cnf

Code:
[mysqld]
datadir=/usr/local/mysql/data
#/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#socket=/tmp/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1

[mysql.server]
user=mysql
#basedir=/var/lib
basedir=/usr/local/mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
#
socket=/var/lib/mysql/mysql.sock

what I do wrong ?
 
Code:
service mysqld restart
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
 
I have installed freebsd ..

sever# /usr/local/etc/rc.d/mysqld restart
Stopping mysqld: [ FAILED ]
Starting mysqld: [ OK ]

thanks i add this link but it does not help me :(

When I try to connect from console

I get

sever# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (61)
 
Last edited:
just a suggestion:

do

#ps -aux | grep mysql

to see if mysql is running first?

u shuld also check the permissions in /var/lib/mysql directory for mysql user
 
Back
Top