ERROR 2002: Can't connect to local MySQL server

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,887 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,274 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 4957 | Replies: 0

•

Join Date: Jun 2005

Posts: 9

Reputation: jpl80 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jpl80

Offline

Newbie Poster

ERROR 2002: Can't connect to local MySQL server

Jan 10th, 2006

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