[已解決] mysql升級報錯，現(xiàn)在啟動不了

druse

我是用這個來升級的


wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh

現(xiàn)在出錯了，Mysql無法啟動 請大家?guī)兔σ幌�，謝謝

1. ERROR! MySQL server PID file could not be found!
   
2. scripts/mysql_install_db.sh: line 325: @HOSTNAME@: command not found
   
3. WARNING: The host '' could not be looked up with resolveip.
   
4. This probably means that your libc libraries are not 100 % compatible
   
5. with this binary MySQL version. The MySQL daemon, mysqld, should work
   
6. normally with the exception that host name resolving will not work.
   
7. This means that you should use IP addresses instead of hostnames
   
8. when specifying MySQL privileges !
   
9. Installing MySQL system tables...
   
10. 140616 13:43:01 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
    
11. ERROR: 1136  Column count doesn't match value count at row 1
    
12. 140616 13:43:01 [ERROR] Aborting
    
13. 
    
14. 140616 13:43:01 [Note] /www/wdlinux/mysql/bin/mysqld: Shutdown complete
    
15. 
    
16. 
    
17. Installation of system tables failed!  Examine the logs in
    
18. /www/wdlinux/mysql/var for more information.
    
19. 
    
20. You can try to start the mysqld daemon with:
    
21. 
    
22.     shell> /www/wdlinux/mysql/bin/mysqld --skip-grant &
    
23. 
    
24. and use the command line tool /www/wdlinux/mysql/bin/mysql
    
25. to connect to the mysql database and look at the grant tables:
    
26. 
    
27.     shell> /www/wdlinux/mysql/bin/mysql -u root mysql
    
28.     mysql> show tables
    
29. 
    
30. Try 'mysqld --help' if you have problems with paths.  Using --log
    
31. gives you a log in /www/wdlinux/mysql/var that may be helpful.
    
32. 
    
33. Please consult the MySQL manual section
    
34. 'Problems running mysql_install_db', and the manual section that
    
35. describes problems on your OS.  Another information source are the
    
36. MySQL email archives available at http://lists.mysql.com/.
    
37. 
    
38. Please check all of the above before mailing us!  And remember, if
    
39. you do mail us, you MUST use the /www/wdlinux/mysql/scripts/mysqlbug script!
    
40. 
    
41. mv: cannot move `/www/wdlinux/mysql/var/mysql' to `/www/wdlinux/mysql/var/mysqlo/mysql': Directory not empty
    
42. ERROR! MySQL server PID file could not be found!
    
43. Starting MySQL. ERROR! The server quit without updating PID file (/www/wdlinux/mysql-5.5.27/data/AY140228220438096255Z.pid).
    
44. 
    
45. 
    
46. Running..., Please Wait...
    
47. err
    
48. mysql update is OK

復(fù)制代碼

druse

http://www.fsowen.com/bbs/viewthread.php?tid=5461
請參照這個帖子，解決問題了

ligq198838

這樣也不能完全解決問題，請到http://www.fsowen.com/bbs/viewthread.php?tid=10582&extra=