LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
Reload this Page [SOLVED] mysql won't start (Centos 5.5 64bit)
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 10-26-2010, 11:03 AM   #1
deliriumfk
LQ Newbie
 
Registered: Sep 2010
Posts: 10

Rep: Reputation: 0
mysql won't start (Centos 5.5 64bit)

Hey,

Ok here's basicaly what i did. On a newly installed centos I updated mysql-* & php-* files using RPM repository, and I installed phpmyadmin. After that i tried restarting mysql and it just said: failed

Code:
service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
Code:
101026 18:47:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101026 18:47:07 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 641 error messages.
Check that the above file is the right version for this program!
101026 18:47:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Unknown error 1146
101026 18:47:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101026 18:47:07  InnoDB: Started; log sequence number 0 43655
101026 18:47:07 [ERROR] Aborting

101026 18:47:07  InnoDB: Starting shutdown...
101026 18:47:13  InnoDB: Shutdown completed; log sequence number 0 43655
101026 18:47:13 [Note] 
101026 18:47:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

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

Code:
PHP 5.3.3 (cli) (built: Jul 22 2010 17:12:45) 
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
Last edited by deliriumfk; 10-27-2010 at 02:55 AM.
 
Old 10-26-2010, 12:46 PM   #2
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

MySQL is trashed. You definitely want to reinstall it.

SUGGESTION:
1. Make sure mysql service is STOPPED

2. DEINSTALL MySql

3. REINSTALL MySQL

4. Verify that you can start/stop mysql manually

If you still have problems, please cut/paste the following:
1. Your exact "install mysql" command
2. Any errors/warnings from the command
3. Your /var/log/messages warnings/errors from the manual restart
 
Old 10-26-2010, 01:36 PM   #3
deliriumfk
LQ Newbie
 
Registered: Sep 2010
Posts: 10

Original Poster
Rep: Reputation: 0
1. I've installed centos 5.5 64 bit including httpd, mysql packages.
2. A ran yum update.
3. I updated php:

Code:
wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm
yum --enablerepo=remi update php
4. I installed phpmyadmin using this tutorial:

Code:
   1. $ su -
   2. # cd /var/www/html
   3. # wget -c http://prdownloads.sourceforge.net/phpmyadmin/
      phpMyAdmin-3.3.8-english.tar.gz?download
   4. # tar xvfz phpMyAdmin-3.3.8-english.tar.gz
   5. # mv phpMyAdmin-3.3.8-english phpmyadmin
   6. # cd phpmyadmin
   7. # cp config.sample.inc.php config.inc.php
   8. # vi config.inc.php
      :
      $cfg['Servers'][$i]['auth_type'] = ‘http‘; # default is cookies
      :
   9. # service httpd restart
5. I update mysql using yum --enablerepo=remi update mysql
and well, after (5) things got messed up.

Now i tried to remove mysql using yum remove, but when I try to install it again I get this:

Code:
Transaction Check Error:
  file /etc/my.cnf from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/english/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/estonian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/french/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/german/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/greek/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/italian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/japanese/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/korean/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/polish/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/romanian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/russian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/serbian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysql-libs-5.1.51-1.el5.remi.x86_64
  file /usr/lib64/mysql/libmysqlclient.so.15.0.0 from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysqlclient15-5.0.67-1.el5.remi.x86_64
  file /usr/lib64/mysql/libmysqlclient_r.so.15.0.0 from install of mysql-5.0.77-4.el5_5.3.x86_64 conflicts with file from package mysqlclient15-5.0.67-1.el5.remi.x86_64

Error Summary
-------------
No idea how to remove packages *-5.1.51-1... I've deleted the /usr/share/mysql directory.
 
Old 10-26-2010, 02:57 PM   #4
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

Code:
yum remove mysqlclient15-5.0.67-1.el5.remi.x86_64
yum remove mysql-libs-5.1.51-1.el5.remi.x86_64
Also:
Code:
yum install mysql mysql-server php-mysql
 
Old 10-27-2010, 02:55 AM   #5
deliriumfk
LQ Newbie
 
Registered: Sep 2010
Posts: 10

Original Poster
Rep: Reputation: 0
Hey,

This helped:

Code:
# rpm -e --nodeps mysqlclient15-5.0.67-1.el5.remi.x86_64
# rpm -e --nodeps mysql-libs-5.1.51-1.el5.remi.x86_64

yum install mysql-server.x86_64
& problem solved.
 
Old 06-02-2011, 03:08 PM   #6
aneeshtan
LQ Newbie
 
Registered: Jun 2011
Posts: 4

Rep: Reputation: Disabled
hey guys

when I remove mysql server and reinstalling it, would it remove all my current databases and their data ?

cause I have problem in starting mysql server
 
  


Reply



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
CentOS 5.4 64bit php-gd issue Nicarlo Linux - Newbie 4 03-11-2012 02:53 PM
I have RHEL 5.0 and MySQL start problem, my MySQL server doesn't start rsatya Linux - Enterprise 4 02-03-2009 12:04 PM
CentOS 5 64bit - openldap - missing back_bdb.so neocontrol Red Hat 5 09-04-2008 08:23 AM
libgaim.so.0()(64bit) error | centos Cheza Linux - General 1 01-12-2008 10:32 AM
Wireshark Install On CentOS 64bit krams Linux - Newbie 3 04-24-2007 04:35 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:25 AM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
Main Menu
Advertisement
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
Open Source Consulting | Domain Registration