lost of pid file of my server, I can't stop mysql using normal commands like
service mysql stop
which will show
ERROR! MySQL server PID file could not be found!
So I try to stop all mysql processes and restart mysql mannually
I've searched the Internet and found one solution, but it doesn't work for me.
ps aux | grep mysql
and the result shows
root 6490 0.0 0.2 112720 2332 pts/0 S+ 03:48 0:00 grep --color=auto mysql
So I type
kill -9 6490
but the result is
-bash: kill: (6490) - No such process
It seems every time I try to kill it, the pid changes.
How can I really stop all mysql processes? Then be able to get a new pid file? New to linux and mysql, thank you in advance!
Thanks to Henryk Gerlach's answer, it seems I have shut down all Mysql processes, but after I restart my server the pid file doesn't auto-generate. How should I do to really make my Mysql back to normal??