another mysqld process using the same InnoDB data or log files

Question

I have a mysql server running on linux system. i'm already running one c++ prog which is building up the data base with current date and time stamp. I'm trying to run another process in c++ which is accessing different db but i'm having error.

error is as below:

InnoDB: check that you do not have another mysqld process
InnoDB: using the same InnoDB data or log files
InnoDB: Unable to lock /var/lib/mysql/ibdata1, error: 11

please can somebody explain whats going wrong in here

thanks

Answer 1

I was solved this problem by kill mysqld process

To kill all mysqld process on Linux :

# killall mysqld mysqld_safe

---

Wait for 10 seconds atleast so that it shut down cleanly.

Now, run this command to check whether still there are some mysqld process remained or not ?

# ps aux | grep mysqld

---

If you still able to see more than run this command :

killall -9 mysqld mysqld_safe

---

This will kill all mysqld processes.