LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-28-2010, 01:09 AM   #1
Muthu I
LQ Newbie
 
Registered: May 2010
Location: India
Distribution: Fedora
Posts: 14

Rep: Reputation: 1
Error during MySQL Configuration .


Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
100527 18:26:49 [ERROR] Aborting

100527 18:26:49 [Note] /usr/local/libexec/mysqld: Shutdown complete

Installation of system tables failed!
 
Old 05-28-2010, 01:35 AM   #2
spampig
Member
 
Registered: Feb 2010
Location: /Earth/UK/England/Hampshire
Distribution: Debian, Ubuntu, CentOS, Slackware
Posts: 262
Blog Entries: 2

Rep: Reputation: 56
Hi,

It would be helpful if you stated the Distro (Guessing Fedora???), the method you have used to download/obtain mysql and the steps to recreate the issue you are having.
 
Old 05-28-2010, 01:39 AM   #3
EricTRA
LQ Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 20 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295
Hello,

What version of MySQL are you installing and on what OS? Is it a new complete install of MySQL or an upgrade?

Kind regards,

Eric
 
Old 05-28-2010, 02:50 AM   #4
Muthu I
LQ Newbie
 
Registered: May 2010
Location: India
Distribution: Fedora
Posts: 14

Original Poster
Rep: Reputation: 1
Quote:
Originally Posted by EricTRA View Post
Hello,

What version of MySQL are you installing and on what OS? Is it a new complete install of MySQL or an upgrade?

Kind regards,

Eric
MySQL 5.0.90 on Fedorra 11 . It is a complete install. I already have another MySQL. Now, I am installing in a new place. The error occurred when I gave "./mysql_install_db " . ./configure, make and make install are over. Please help.
 
Old 05-28-2010, 03:08 AM   #5
EricTRA
LQ Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 20 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295Reputation: 1295
Hi,

One question comes to mind: is there any specific reason why you're compiling from source instead of installing using the package manager?

Kind regards,

Eric
 
Old 05-28-2010, 04:46 AM   #6
Muthu I
LQ Newbie
 
Registered: May 2010
Location: India
Distribution: Fedora
Posts: 14

Original Poster
Rep: Reputation: 1
Quote:
Originally Posted by EricTRA View Post
Hi,

One question comes to mind: is there any specific reason why you're compiling from source instead of installing using the package manager?

Kind regards,

Eric
I want to learn the process. It's an assignment.
 
Old 05-28-2010, 01:15 PM   #7
hda7
Member
 
Registered: May 2009
Distribution: Debian wheezy
Posts: 251

Rep: Reputation: 31
It looks like maybe mysql_install_db is trying to install in the location of your old db's, and the row size of one of the tables changed between mysql versions. See if you can specify an install location.
 
  


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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2) peteyperson Linux - Server 2 03-04-2009 02:16 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM


All times are GMT -5. The time now is 11:27 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration