Results 1 to 4 of 4
Thread: Missing Mysql.sock
-
06-01-2005, 02:55 AM #1Junior Guru Wannabe
- Join Date
- Sep 2004
- Location
- South Africa
- Posts
- 55
Missing Mysql.sock
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").
~~~~~~~~~~~~~~~~~~~~~~
-
06-01-2005, 03:09 AM #2Junior Guru Wannabe
- Join Date
- Oct 2004
- Location
- India
- Posts
- 80
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.
-
06-01-2005, 03:38 AM #3Junior Guru Wannabe
- Join Date
- Sep 2004
- Location
- South Africa
- Posts
- 55
worked like a charm ... you're the man.
Thanx a million
-
06-01-2005, 01:09 PM #4Web Hosting Master
- Join Date
- Nov 2004
- Location
- India
- Posts
- 1,104
You can also try this command :
# /usr/local/cpanel/bin/sqlsocketcheck
Then 'service mysql start'AssistanZ - Beyond Boundaries...
Cloudstack Consultancy / 24x7 Web Hosting Support / 24x7 Server Management / Infrastructure Management Services
Web & Mobile Apps Development / Web Designing Services / Php, Grails, Java Development