Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Discussion in 'Server Operation' started by nathandr, Oct 6, 2009.

  1. nathandr

    nathandr New Member

    Mysql server fails to start with following error - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Any help please?

    OS:Debian
    Mysql version :5.0

    /var/log/mysql.err 0kb
    /var/log/mysql/mysql-bin.index 0kb (no other logs found in /var/log/mysql)

    /etc/mysql/my.cnf
    [client]
    port = 3306
    socket = /var/run/mysqld/mysqld.sock

    [mysqld_safe]
    socket = /var/run/mysqld/mysqld.sock
    nice = 0

    skip-bdb

    set-variable = innodb_buffer_pool_size=2M
    set-variable = innodb_additional_mem_pool_size=500K
    set-variable = innodb_log_buffer_size=500K
    set-variable = innodb_thread_concurrency=2
    [mysqld]
    set-variable=local-infile=0
    set-variable=max_connections=200

    user = mysql
    pid-file = /var/run/mysqld/mysqld.pid
    socket = /var/run/mysqld/mysqld.sock
    port = 3306
    basedir = /usr
    datadir = /var/lib/mysql
    tmpdir = /tmp
    language = /usr/share/mysql/english
    skip-external-locking

    key_buffer = 16M
    max_allowed_packet = 16M
    thread_stack = 128K
    thread_cache_size = 8
    query_cache_limit = 1M
    query_cache_size = 16M

    log_bin = /var/log/mysql/mysql-bin.log
    # WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
    expire_logs_days = 10
    max_binlog_size = 100M
    g_bin = /var/log/mysql/mysql-bin.log


    set-variable = innodb_buffer_pool_size=2M
    set-variable = innodb_additional_mem_pool_size=500K
    set-variable = innodb_log_buffer_size=500K
    set-variable = innodb_thread_concurrency=2
    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 16M

    [mysql]
    #no-auto-rehash # faster start of mysql but no tab completition

    [isamchk]
    key_buffer = 16M

    !includedir /etc/mysql/conf.d/
     
  2. falko

    falko Super Moderator Howtoforge Staff

    What are the outputs of
    Code:
    ps aux|grep mysql
    and
    Code:
    ls -la /var/run/mysqld/
    ?
     

Share This Page