Board logo

标题: [已解决] mysql升级报错,现在启动不了 [打印本页]

作者: druse    时间: 2014-6-16 14:22     标题: mysql升级报错,现在启动不了

本帖最后由 druse 于 2014-6-16 14:28 编辑

我是用这个来升级的


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

现在出错了,Mysql无法启动 请大家帮忙一下,谢谢

  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. 140616 13:43:01 [Note] /www/wdlinux/mysql/bin/mysqld: Shutdown complete


  14. Installation of system tables failed!  Examine the logs in
  15. /www/wdlinux/mysql/var for more information.

  16. You can try to start the mysqld daemon with:

  17.     shell> /www/wdlinux/mysql/bin/mysqld --skip-grant &

  18. and use the command line tool /www/wdlinux/mysql/bin/mysql
  19. to connect to the mysql database and look at the grant tables:

  20.     shell> /www/wdlinux/mysql/bin/mysql -u root mysql
  21.     mysql> show tables

  22. Try 'mysqld --help' if you have problems with paths.  Using --log
  23. gives you a log in /www/wdlinux/mysql/var that may be helpful.

  24. Please consult the MySQL manual section
  25. 'Problems running mysql_install_db', and the manual section that
  26. describes problems on your OS.  Another information source are the
  27. MySQL email archives available at http://lists.mysql.com/.

  28. Please check all of the above before mailing us!  And remember, if
  29. you do mail us, you MUST use the /www/wdlinux/mysql/scripts/mysqlbug script!

  30. mv: cannot move `/www/wdlinux/mysql/var/mysql' to `/www/wdlinux/mysql/var/mysqlo/mysql': Directory not empty
  31. ERROR! MySQL server PID file could not be found!
  32. Starting MySQL. ERROR! The server quit without updating PID file (/www/wdlinux/mysql-5.5.27/data/AY140228220438096255Z.pid).


  33. Running..., Please Wait...
  34. err
  35. mysql update is OK
复制代码


作者: druse    时间: 2014-6-16 14:28

http://www.wdlinux.cn/bbs/viewthread.php?tid=5461
请参照这个帖子,解决问题了
作者: ligq198838    时间: 2016-5-24 20:38

这样也不能完全解决问题,请到http://www.wdlinux.cn/bbs/viewthread.php?tid=10582&extra=




欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2