cPanel/WHM

Hi,

I have replaced my.cnf file from existing to optimized my.cnf. I forgot to stop MySQL while replacing the file. Now I got the below error while starting/restarting MySQL:

----------------------------
# service mysql restart
ERROR! MySQL PID file could not be found!
Starting MySQL................................... ERROR!

In /usr/sbin/mysqld I got the following error:

# /usr/sbin/mysqld
050602 14:17:44 [Warning] Asked for 196608 thread stack, but got 126976
050602 14:17:44 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
050602 14:17:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
050602 14:17:44 [ERROR] Aborting
---------------------------------

Can someone help me to fix this?

Thanks,

Mike

[cPanel/WHM Configuration]

It seems that MySQL process is running hence you are unable to use the port. You can check the running MySQL process using following command:

ps auxf | grep mysql

If you get any MySQL process kill that process ID using kill -9 PID and then try to start MySQL.

Kailash

Thanks Kailash!

It did the trick.

Mike