MySQL Daemon failed to start... Help required...

Installing, Configuring, Troubleshooting server daemons such as Web and Mail
Post Reply
mehawk
Posts: 5
Joined: 2014/08/04 10:08:41

MySQL Daemon failed to start... Help required...

Post by mehawk » 2014/08/04 10:32:06

Hello everyone,

When I try to restart mysql daemon it using this:

Code: Select all

service mysqld stop
service mysqld start
or

Code: Select all

service mysqld restart
it gives me an error:

MySQL Daemon failed to start.

here is the result of rpm -qa mysql\* | sort

Code: Select all

rpm -qa mysql\* | sort
mysql-5.1.58-jason.1
mysql-server-5.1.58-jason.1
mysqlclient15-5.0.91-1.jason.1
i got this error when i tried to upgrade mysql apparently i using mixed versions... I am unable to show error logs i don't know if i am doing something wrong or logs have been removed...

Please help me removing this problem.. Your help will be really appreciated.

Regards, Mehroz Anjum

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: MySQL Daemon failed to start... Help required...

Post by TrevorH » 2014/08/04 10:42:12

You've installed a non-CentOS copy of mysql from the "utterramblings" repo. Uninstall it and use the CentOS supplied version.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

mehawk
Posts: 5
Joined: 2014/08/04 10:08:41

Re: MySQL Daemon failed to start... Help required...

Post by mehawk » 2014/08/04 10:59:48

TrevorH wrote:You've installed a non-CentOS copy of mysql from the "utterramblings" repo. Uninstall it and use the CentOS supplied version.
TrevorH can you please guide me as i am new to centos..

I also forgot to mention i am running kloxo lxadmin and i don't want to loose databases...

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: MySQL Daemon failed to start... Help required...

Post by TrevorH » 2014/08/04 11:44:28

I'm afraid that kloxo is completely unsupported here. It makes so many changes to the underlying operating system that any advice we might offer that would apply to a CentOS system might break one with kloxo installed more than it already is.

In addition, I have looked at kloxo in the past and found that it is not something that I would have within 1000 miles of any of my servers.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

mehawk
Posts: 5
Joined: 2014/08/04 10:08:41

Re: MySQL Daemon failed to start... Help required...

Post by mehawk » 2014/08/04 11:57:55

TrevorH wrote:I'm afraid that kloxo is completely unsupported here. It makes so many changes to the underlying operating system that any advice we might offer that would apply to a CentOS system might break one with kloxo installed more than it already is.

In addition, I have looked at kloxo in the past and found that it is not something that I would have within 1000 miles of any of my servers.
Actually you are right about kloxo... but my only option is to repair it :(

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: MySQL Daemon failed to start... Help required...

Post by TrevorH » 2014/08/04 12:57:24

On a system without kloxo you would remove or disable the utterramblings repo by either removing the rpm that installed it or by editing the /etc/yum.repos.d file for it and flipping enabled=1 to 0. Then once that was done you'd make sure that mysqld was stopped and then yum downgrade mysql\* - probably having backed up the contents of /var/lib/mysql beforehand!
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

mehawk
Posts: 5
Joined: 2014/08/04 10:08:41

Re: MySQL Daemon failed to start... Help required...

Post by mehawk » 2014/08/04 13:19:28

yum downgrade is not working i tried to use yum downgrade but looks like yum downgrade is not available

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: MySQL Daemon failed to start... Help required...

Post by TrevorH » 2014/08/04 18:46:47

You sure you have CentOS 5? The yum downgrade command should be available on CentOS 5 and it needs a package name or pattern that matches multiple packages passed to it - so for example, yum downgrade mysql mysql-server
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

mehawk
Posts: 5
Joined: 2014/08/04 10:08:41

Re: MySQL Daemon failed to start... Help required...

Post by mehawk » 2014/08/05 03:12:32

TrevorH wrote:You sure you have CentOS 5? The yum downgrade command should be available on CentOS 5 and it needs a package name or pattern that matches multiple packages passed to it - so for example, yum downgrade mysql mysql-server
yes i am sure its CentOS release 5 (Final)

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: MySQL Daemon failed to start... Help required...

Post by gerald_clark » 2014/08/05 03:32:28

Well, you have not actually shown us a yum run or the output of 'uname -a'.
Also show the output of 'grep -R exclude /etc/yum*'

Post Reply