注冊(cè) 登錄關(guān)注:

WDlinux官方論壇 » wdCP V2|linux下免費(fèi)的服務(wù)器/虛擬主機(jī)管理系統(tǒng) » mysql升級(jí)報(bào)錯(cuò)，現(xiàn)在啟動(dòng)不了

返回列表發(fā)帖

druse

注冊(cè)會(huì)員

Rank: 2

1^# 跳轉(zhuǎn)到 » 倒序看帖

打印

字體大小: tT

發(fā)表于 2014-6-16 14:22 | 只看該作者

提問三步曲: 提問先看教程/FAQ索引(wdcp,wdcp_v3,一鍵包)及搜索,會(huì)讓你更快解決問題
1 提供詳細(xì)，如系統(tǒng)版本,wdcp版本,軟件版本等及錯(cuò)誤的詳細(xì)信息,貼上論壇或截圖發(fā)論壇
2 做過哪些操作或改動(dòng)設(shè)置等

溫馨提示：信息不詳,很可能會(huì)沒人理你！論壇有教程說明的，也可能沒人理！因?yàn)?你懂的

[已解決] mysql升級(jí)報(bào)錯(cuò)，現(xiàn)在啟動(dòng)不了

本帖最后由 druse 于 2014-6-16 14:28 編輯

我是用這個(gè)來升級(jí)的

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

現(xiàn)在出錯(cuò)了，Mysql無法啟動(dòng) 請(qǐng)大家?guī)兔σ幌拢x謝

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