LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 09-27-2011, 05:04 AM   #1
Alexrkkl
LQ Newbie
 
Registered: Jun 2011
Location: Birmingham, England
Distribution: RedHat Enterprise 5.6
Posts: 27

Rep: Reputation: Disabled
Error installing newer version of MySQL on red hat enterprise 5.7


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:
Code:
/usr/bin/mysql_secure_installation
I run through this installation fine but then I try to check the status and restart MySQL with:

Code:
service mysql status
Code:
Service mysql restart
But I get these errors respectively:

Code:
MySQL is not running, but lock exists   [FAILED]
Code:
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.

-Alex


[update]
Since this post I tried installing again but this time I couldn't complete this:

Code:
/usr/bin/mysql_secure_installation
when it asks for the current root password I enter the password it comes back with:

Code:
 ERROR 2002 (HY000): can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Last edited by Alexrkkl; 09-27-2011 at 08:13 AM. Reason: Update
 
Old 09-27-2011, 07:04 PM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
Try 'service mysqld stop' then 'service mysqld start' - the stop should clean up any pid/lock files

Exactly how did you go about installing?

Last edited by kbp; 09-27-2011 at 07:06 PM.
 
Old 09-28-2011, 03:59 AM   #3
Alexrkkl
LQ Newbie
 
Registered: Jun 2011
Location: Birmingham, England
Distribution: RedHat Enterprise 5.6
Posts: 27

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by kbp View Post
Try 'service mysqld stop' then 'service mysqld start' - the stop should clean up any pid/lock files

Exactly how did you go about installing?
Thanks for the reply I installed from an RPM that I downloaded from the MySQL website and installed it using the command:

Code:
rpm -ivh MySQL-server-community-5.1.59-1.rhel5.i386.rpm (same for client)
When I issue the 'service mysqld stop' command the error:

Code:
MySQL manager or server PID file could not be found   [FAILED]
Thanks for the reply.
 
Old 09-28-2011, 05:35 PM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
And 'service mysqld start' doesn't work after stop? ... anything in /var/log/mysqld.log ?

Could also run 'rpm -ql MySQL-server-community | grep init' ? .. there seems to be a discrepancy between the name I see (mysqld) and the name you see (mysql)

Last edited by kbp; 09-28-2011 at 05:37 PM.
 
Old 09-28-2011, 10:41 PM   #5
hhh123
Member
 
Registered: Jul 2009
Location: /
Distribution: centos
Posts: 47

Rep: Reputation: 1
HI Alex, have you installed all the dependencies of mysql ?? i think you can get more information in /var/log/mysql/mysql.log and /var/log/messages
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Red Hat Enterprise Linux version? saudoi Linux - Enterprise 2 05-20-2006 08:52 AM
what last version/release of Red Hat enterprise Linux AS? xcore_on Linux - Newbie 1 05-11-2006 04:28 AM
Problem installing MySQL 5.0.2-alpha on Red Hat Enterprise ES V3 ETSUSnake Linux - Software 2 03-08-2005 10:24 AM
How to check the Red Hat Enterprise version? nju Linux - Newbie 2 03-02-2005 01:45 PM


All times are GMT -5. The time now is 01:24 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration