ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 安装mysql遇到ERROR: 1136 Column count doesn't match value count at row 1

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

原创 Linux操作系统 作者:myownstars 时间:2011-07-20 15:45:14 0 删除 编辑

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 http://lists.mysql.com/.

 

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目录删掉

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-702655/,如需转载,请注明出处,否则将追究法律责任。

下一篇: linux配置yum
请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3112066