hosted by liquidweb


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

Forum Jump

Missing Mysql.sock

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old
Junior 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").
~~~~~~~~~~~~~~~~~~~~~~



Sponsored Links
  #2  
Old
Junior Guru Wannabe
 
Join Date: Oct 2004
Location: India
Posts: 80
Log into the shell :

And place this in the /etc/my.cnf

Quote:

[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.

__________________
AssuredHost.Com
Secured Shared and Reseller Web hosting Solutions
We Host Your Trust

  #3  
Old
Junior Guru Wannabe
 
Join Date: Sep 2004
Location: South Africa
Posts: 55
worked like a charm ... you're the man.

Thanx a million

Sponsored Links
  #4  
Old
Web Hosting Master
 
Join Date: Nov 2004
Location: India
Posts: 1,101
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


Reply

Related posts from TheWhir.com
Title Type Date Posted
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Upcoming WHIR Webinar: How Best Practices Can Help Make Children - and Your Hosting Company - Safer Blog 2014-04-09 11:45:43
How Best Practices Can Help Make Children -- and Your Hosting Company -- Safer Webinars 2014-06-10 11:03:06
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
WHT Host Brief Email:

We respect your privacy. We will never sell, rent, or give away your address to any outside party, ever.

Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?