前面一切正常当执行/usr/local/mysql/bin/mysql_install_db这个的时候就进行不下去,本人新手,提示已贴出来了,请高手解答!谢谢了!
[root@Danny mysql-5.0.45]# /usr/local/mysql/bin/mysql_install_db
Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
110317 17:13:36 [ERROR] Aborting
110317 17:13:36 [Note] /usr/local/mysql/libexec/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:
/usr/local/mysql/libexec/mysqld --skip-grant &
and use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/local/mysql/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.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!
|
极有可能是你没有卸载干净 而且原先的版本和现在的版本差很大
你原先的版本是怎么卸载的? 你卸载之后 把原先的数据目录也彻底删除 比如rm -rf /var/lib/mysql/*
另外 你最好加一个mysql用户来用于mysql服务器 在mysql_install_db指定用mysql用户
仔细参照一下我给你的博客 或者mysql自带的安装说明