Results 1 to 4 of 4
  1. #1
    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").
    ~~~~~~~~~~~~~~~~~~~~~~

  2. #2
    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.
    AssuredHost.Com
    Secured Shared and Reseller Web hosting Solutions
    We Host Your Trust

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

    Thanx a million

  4. #4
    Join Date
    Nov 2004
    Location
    India
    Posts
    1,100
    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

  5. Newsletters

    Subscribe Now & Get The WHT Quick Start Guide!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •