标题:
[已解决]
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无法启动 请大家帮忙一下,谢谢
ERROR! MySQL server PID file could not be found!
scripts/mysql_install_db.sh: line 325: @HOSTNAME@: command not found
WARNING: The host '' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
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).
ERROR: 1136 Column count doesn't match value count at row 1
140616 13:43:01 [ERROR] Aborting
140616 13:43:01 [Note] /www/wdlinux/mysql/bin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/www/wdlinux/mysql/var for more information.
You can try to start the mysqld daemon with:
shell> /www/wdlinux/mysql/bin/mysqld --skip-grant &
and use the command line tool /www/wdlinux/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /www/wdlinux/mysql/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /www/wdlinux/mysql/var that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /www/wdlinux/mysql/scripts/mysqlbug script!
mv: cannot move `/www/wdlinux/mysql/var/mysql' to `/www/wdlinux/mysql/var/mysqlo/mysql': Directory not empty
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/www/wdlinux/mysql-5.5.27/data/AY140228220438096255Z.pid).
Running..., Please Wait...
err
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