Hi there I am currently trying to upgrade my version of MySQL on a red-hat enterprise 5.6. I have removed the MySQL version that this was shipped with and I am trying to install version 5.1.59.
I install the distribution fine and then issue the command:
I run through this installation fine but then I try to check the status and restart MySQL with:
service mysql status
Service mysql restart
But I get these errors respectively:
MySQL is not running, but lock exists [FAILED]
MySQL manager or server PID file could not be found!
Starting MySQL ........... Manager of pid-file quit without updating file.
Thanks in advance for any help received.
Since this post I tried installing again but this time I couldn't complete this:
when it asks for the current root password I enter the password it comes back with:
ERROR 2002 (HY000): can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)