• 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. Understanding the REVOKE statement in MySQL
  2. Beginners Guide to Management of MySQL Cluster Log Files
  3. How to Migrate from Oracle to MySQL
  4. How to Install MySQL Cluster on a single server for testing purposes
  5. How To Reset MySQL 8.0 Root Password On Windows
  6. How to use foreign keys to attain referential integrity in MySQL
  7. Can MySQL Cluster Run Multiple Nodes On a Single Server
  8. Beginners Guide to MySQL User Management
  9. “Access denied for user ‘username’@’hostname’ (using password: YES)” – Error while connecting MySQL with PHP
  10. How to Set Space limits for MySQL for database/schema/table

You May Also Like

Primary Sidebar

Recent Posts

  • What are Command Rules in oracle Database
  • Using Rule Sets in Oracle Database Vault
  • How Realms Work in Oracle Database Vault
  • How to use Privilege Analysis in Oracle Database
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary