在线的兄弟们帮一把吧！！ MYSQL起不来了！

rosvpn

主机是CENTOS4。3做WWW
MYSQL是4。12版

昨天晚上本打算用phpmyadmin建立一个非本地用户，之后创建完毕之后就启动不起来了

后来把备份的nysql数据库恢复到没建立用户前，也还是起不来，老大们，帮帮吧！

root@sdsd ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
启动 MySQL： [失败]

这是日志

1. 081014 04:34:04  mysqld started
   
2. 081014  4:34:04  InnoDB: Started; log sequence number 0 43654
   
3. 081014  4:34:04 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
   
4. 081014  4:34:04 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
   
5. 081014  4:34:04 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
   
6. 081014  4:34:04 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
   
7. 081014 04:34:04  mysqld ended
   
8. 
   
9. 081014 12:14:14  mysqld started
   
10. 081014 12:14:14  InnoDB: Started; log sequence number 0 43654
    
11. 081014 12:14:14 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
    
12. 081014 12:14:14 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
    
13. 081014 12:14:14 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
    
14. 081014 12:14:14 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
    
15. 081014 12:14:14  mysqld ended

复制代码

yueliangdao0608

运行一下

mysql_fix_privilege_tables

rosvpn

1. [root@sdsd ~]# mysql_fix_privilege_tables
   
2. This script updates all the mysql privilege tables to be usable by
   
3. MySQL 4.0 and above.
   
4. 
   
5. This is needed if you want to use the new GRANT functions,
   
6. CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1
   
7. 
   
8. Got a failure from command:
   
9. /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
   
10. Please check the above output and try again.
    
11. 
    
12. Running the script with the --verbose option may give you some information
    
13. of what went wrong.
    
14. 
    
15. If you get an 'Access denied' error, you should run this script again and
    
16. give the MySQL root user password as an argument with the --password= option

复制代码

提示这个

yueliangdao0608

对应的用户以及密码。

猪知猪之道

原帖由 yueliangdao0608 于 2008-10-14 12:57 发表
对应的用户以及密码。

数据库没起来，好像是不行的吧， 这个修复

rosvpn

数据库没起来呀 没办法对应密码呀， 现在数据库的用户是root 密码还是以前的。 已经把备份过的mysql数据传到/var/lib/mysql下了  怎么办呀。 这个是NAT主机没办法重起！

dahai01

default-character-set=    ??
实在不行初始化 。。。

[ 本帖最后由 dahai01 于 2008-10-14 14:46 编辑 ]

rosvpn

原帖由 dahai01 于 2008-10-14 14:43 发表
default-character-set=    ??
实在不行初始化 。。。

怎么初始化啊？ 现在这机器不能重起，只要不重起，能弄好就行， 帮帮俺吧， 老大您QQ多少，

猪知猪之道

原帖由 dahai01 于 2008-10-14 14:43 发表
default-character-set=    ??
实在不行初始化 。。。

够狠，  

看错误是字符集的问题
你看看  share/mysql/charsets 目录下的 文件是不是有问题了

Fatal error: mysql.user table is damaged or in unsupported 3.20 format

[ 本帖最后由 猪知猪之道 于 2008-10-14 15:11 编辑 ]

rosvpn

够狠，   

看错误是字符集的问题
你看看  share/mysql/charsets 目录下的 文件是不是有问题了


怎么看啊 老大加下我QQ帮俺整整吧， 实在是郁闷了！  QQ 710062554