MySQL does not generating PID file
I got the sollution,

1:extract your new mysql file :-
tar -zxf mysql-5.1.58.tar.gz

2:Rename the old errmsg.sys file which is in error file showing
mv /usr/share/mysql/english/errmsg.sys /usr/share/mysql/english/errmsg.sys.old

3:copy the new errmsg.sys file to exsting place
cp mysql-5.1.58/sql/share/english/errmsg.sys /usr/share/mysql/english/errmsg.sys

4:start your server.
 service mysql start

for Detail explanation kindly refer this link

http://toastergremlin.com/?p=447