Collapse

Announcement

Collapse
No announcement yet.

Mysql Down

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql Down

    Hi guys,

    I am getting the following error and database server is down, All sites are having problems. Please provide a quick fix solution.
    Code:
    # mysql -uname -p  
    ERROR 2002 (HY000): Can't connect to local MySQL server through    socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

  • #2
    What's the output of the below command, paste here last 4-6 lines.

    Code:
    cat /var/lib/mysql/hostname.domain.com.err
    
    NOTE:- hostname.domain.com should be your actual hostname of your server.
    Also, check if there is any other instance of MySQL running on your server?

    Code:
    ps aux|grep mysql
    Last edited by ameya; 12-06-2017, 02:48 PM.

    Comment

    Working...
    X