• 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. Managing MySQL Using Systemd As A Non Root User
  2. MySQL Server 8.0 – How to create a REPLICATION SLAVE using MEB
  3. Understanding mysqlcheck and myisamchk utilities
  4. Granting All Privileges On All databases Except One Specific Table in MySQL
  5. How To Start And Stop MySQL Cluster
  6. How to gather information on the MySQL 8 Roles and Privileges assigned to a user without using SHOW GRANTS
  7. MySQL – How to Backup User Privileges as CREATE USER and/or GRANT Statements
  8. What is the purpose of “mysql.sys@localhost” user
  9. Beginners Guide to Implementing Table Maintenance in MySQL
  10. MySQL : how to set (change) user password

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright