• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

“Another MySQL daemon already running with the same unix socket” – error while starting MYSQL

by admin

In our environment we had run cluster fencing tests, after hard-reboot our MySQL will not start.

# service mysqld status
mysqld is stopped
# service mysqld start
Another MySQL daemon already running with the same unix socket.
Starting mysqld:                                           [FAILED]

The Solution

The root cause of the above error is that MySQL was not closed properly, during database shutdown. Due to this socket file is not removed by MySQL and had to be removed manually.

1. Verify that MySQL is not running on your system:

# ps aux | grep -i sql
root     10154  0.0  0.0 103252   840 pts/0    S+   11:21   0:00 grep -i sql

2. Remove leftover socket file using following command:

# rm -Rf /var/lib/mysql/mysql.sock

3. Start the MySQL database and verify if its running properly.

# service mysqld start
# service mysqld status

Filed Under: mysql

Some more articles you might also be interested in …

  1. What are Reserved User Accounts in MySQL
  2. How to reset MySQL database root password
  3. How can I get Excel data into MySQL, or vice versa?
  4. MySQL : How To Find the Slowest Queries
  5. “expect” script to provide password to mysql_config_editor
  6. mysqldump – How to Restore a Specific Database From a Backup of All Databases
  7. How to Disable Client Access Control in MySQL
  8. How to install and configure MySQL sys schema
  9. How to Restore a Specific Database or Table (MySQL)
  10. What is an Arbitrator in MySQL Cluster

You May Also Like

Primary Sidebar

Recent Posts

  • aws ec2: CLI for AWS EC2 (Command Examples)
  • aws cur – Create, query, and delete AWS usage report definitions (Command Examples)
  • aws configure – Manage configuration for the AWS CLI (Command Examples)
  • aws cognito-idp: Manage Amazon Cognito user pool and its users and groups using the CLI

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright