If you are getting [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 in CloudLinux, following steps will help you.
First, stop MySQL service using following command:
# service mysql stop
and ensure that no MySQL processes are running using following command:
# ps aux| grep mysql ### no mysql processes here
# lsof -i:3306 ### nothing here as well
Next, follow below steps:
# mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
# cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1
# service mysql start
Now, use lsof command to verify again:
# lsof -i:3306
You should now see that MySQL is operational:
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 802407 mysql 33u IPv6 13892877 0t0 TCP *:mysql (LISTEN)
If MySQL service still now running, contact us. Our server experts will solve the issue.
[Need assistance to fix this error or install tools? We’ll help you.]