944,129 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 7422
  • MySQL RSS
Jan 10th, 2006
0

ERROR 2002: Can't connect to local MySQL server

Expand Post »
I cannot get MySQL working. Can someone please help? I have changed permissions on the /var/lib/msql directory and I still can't get it started.

Running Suse Linux Enterprise Server 9

# mysql -V
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)

# mysql start
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I have checked /var/lib/mysql and there is no mysql.sock. I created one with full permissions.

my.cnf
-------------------------------------
# The following options will be passed to all MySQL clients
[client]
password = password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jpl80 is offline Offline
13 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: passing variables threw query
Next Thread in MySQL Forum Timeline: help!! update mysql problem





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC