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

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • 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 is the MySQL Enterprise Monitor?
  2. How To Restore an NDBCluster Backup Using ndb_restore
  3. Beginners Guide to Management of MySQL Cluster Log Files
  4. Beginners Guide to Implementing Table Maintenance in MySQL
  5. mysqldump – How to Restore a Specific Database From a Backup of All Databases
  6. MySQL – How to Backup User Privileges as CREATE USER and/or GRANT Statements
  7. Backup and Restore Of Group Replication Node ( MySQL 8.0 )
  8. MySQL Error “Too many connections” and how to resolve it
  9. How to Troubleshoot InnoDB Lock Issues
  10. How to find Which Process Is Killing mysqld With SIGKILL or SIGTERM on Linux

You May Also Like

Primary Sidebar

Recent Posts

  • How to disable ACPI in CentOS/RHEL 7
  • How to Use real-time query to access data on a physical standby database
  • CentOS/RHEL 8: “ACPI MEMORY OR I/O RESET_REG” Server Hung after reboot
  • How to Create a Physical Standby Database by Using SQL and RMAN Commands
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary