Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Missing Mysql.sock

[bheka]

Hi

I am getting the error message below when trying to start mysql in WHM. I have tried to look for myslq.sock with "whereis" and "slocate" but I still cannot find it.

Please help

~~~~~~~~~~~~~~~~~~~~~~
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
~~~~~~~~~~~~~~~~~~~~~~

[assuredhost.com]

Log into the shell :

And place this in the /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
max_connections=300
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=64
key_buffer=128
join_buffer=1M
max_allowed_packet=16M
table_cache=256
record_buffer=1M
sort_buffer_size=2m
record_buffer=1M
sort_buffer_size=2m
read_buffer_size=2m
read_rnd_buffer_size=768k
max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=64M

This should optmize mysql and fix the socket issue as you restart the mysql server from the shell.

Else paste the error from the shell.

[bheka]

worked like a charm ... you're the man.

Thanx a million

[assistanz247]

You can also try this command :

# /usr/local/cpanel/bin/sqlsocketcheck

Then 'service mysql start'