安裝mysql遇到ERROR: 1136 Column count doesn't match value count at row 1

Linux上安裝mysql反覆遇到這麼一個錯誤

ERROR: 1136  Column count doesn't match value count at row 1

 

詳細資訊如下

[root@justin oracle]# rpm -ivh MySQL-server-5.1.51-1.glibc23.x86_64.rpm

warning: MySQL-server-5.1.51-1.glibc23.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5

Preparing...                ########################################### [100%]

   1:MySQL-server           ########################################### [100%]

ERROR: 1136  Column count doesn't match value count at row 1

110719 18:08:15 [ERROR] Aborting

 

110719 18:08:15 [Note] /usr/sbin/mysqld: Shutdown complete

 

 

Installation of system tables failed!  Examine the logs in

/var/lib/mysql for more information.

 

You can try to start the mysqld daemon with:

 

    shell> /usr/sbin/mysqld --skip-grant &

 

and use the command line tool /usr/bin/mysql

to connect to the mysql database and look at the grant tables:

 

    shell> /usr/bin/mysql -u root mysql

    mysql> show tables

 

Try 'mysqld --help' if you have problems with paths.  Using --log

gives you a log in /var/lib/mysql that may be helpful.

 

Please consult the MySQL manual section

'Problems running mysql_install_db', and the manual section that

describes problems on your OS.  Another information source are the

MySQL email archives available at

 

Please check all of the above before mailing us!  And remember, if

you do mail us, you MUST use the /usr/bin/mysqlbug script!

原因：原有安裝的mysql資訊沒有刪除乾淨，需要將/var/lib/mysql目錄刪掉