新手请教:为何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 & 这个命令执行一下,然后可以启动,但是
关闭后又启动不起来了真是晕倒。
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 & 这个命令执行一下,然后可以启动,但是
关闭后又启动不起来了真是晕倒。
Installing all prepared tables
Fill help tablesTo start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your systemPLEASE 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 benchs in the 'sql-bench' directory:
cd sql-bench ; perl run-all-testsPlease 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
/usr/share/mysql/errmsg.txt内容如下:
[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 engstart-error-number 1000ER_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