新手请教：为何mysql启动会失败？谢了！！

jsntcw

新手请教：为何mysql启动会失败？头疼！！

系统说明：

        LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
        Distributor ID: CentOS
        Description:    CentOS release 5.4 (Final)
        Release:        5.4
        Codename:       Final

              MySQL-server-5.1.7-0.i386.rpm

        原来老的版本是mysql-5.0.77-3.el5，通过yum remove mysql 删除，然后通过
        rpm -ivh MySQL-server-5.1.7-0.i386.rpm进行安装，启动时就失败；


启动情况：

[root@host2 /]# service mysql start
Starting MySQL...................................          [失败]


如果用：cd / ; /usr/bin/mysqld_safe & 这个命令执行一下，然后可以启动，但是
关闭后又启动不起来了。。。真是晕倒。

哪位大哥知道是什么原因啊?

谢谢

jsntcw

有些资料上说未初始化,但执行后还是启动不了.

[root@host2 mysql]# /usr/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h host2.localdomain password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd / ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com


cp my-medium.cnf /etc/my.cnf

jsntcw

错误日志内容如下：

[root@host2 mysql]# vi /usr/share/mysql/errmsg.txt
languages czech=cze latin2, danish=dan latin1, dutch=nla latin1, english=eng latin1, estonian=est latin7, french=fre latin1, german=ger latin1, greek=greek greek, hungarian=hun latin2, italian=ita latin1, japanese=jpn ujis, japanese-sjis=jps sjis, korean=kor euckr, norwegian-ny=norwegian-ny latin1, norwegian=nor latin1, polish=pol latin2, portuguese=por latin1, romanian=rum latin2, russian=rus koi8r, serbian=serbian cp1250, slovak=slo latin2, spanish=spa latin1, swedish=swe latin1, ukrainian=ukr koi8u;

default-language eng

start-error-number 1000

ER_HASHCHK
eng "hashchk"
ER_NISAMCHK
eng "isamchk"
ER_NO
cze "NE"
dan "NEJ"
nla "NEE"
eng "NO"
est "EI"
fre "NON"
ger "Nein"
greek "献?
hun "NEM"
kor "酒聪坷"
nor "NEI"
norwegian-ny "NEI"
pol "NIE"
por "N肙"
rum "NU"
rus "铄?
serbian "NE"
slo "NIE"
ukr "疃"
ER_YES
cze "ANO"
dan "JA"
nla "JA"
eng "YES"
est "JAH"
"/usr/share/mysql/errmsg.txt" 5815L, 354825C