四虎影视在线影院在线观看,小s货再浪些再咬紧点h,国产精品水嫩水嫩,97精产国品一二三产区

標(biāo)題: [教程] 關(guān)于mysql升級到5.5報錯問題 [打印本頁]

作者: happyboy 時間: 2013-4-3 10:56 標(biāo)題: 關(guān)于mysql升級到5.5報錯問題

升級命令wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh

安裝日志錯誤部分
Shutting down MySQL. SUCCESS!
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...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/www/wdlinux/mysql/bin/mysqladmin -u root password 'new-password'
/www/wdlinux/mysql/bin/mysqladmin -u root -h password 'new-password'

Alternatively you can run:
/www/wdlinux/mysql/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /www/wdlinux/mysql ; /www/wdlinux/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /www/wdlinux/mysql/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /www/wdlinux/mysql/scripts/mysqlbug script!

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/localhost.localdomain.pid).

Running..., Please Wait...
err
mysql update is OK

錯誤情況
http://cd-genova.com/bbs/viewthread.php?tid=5137
安裝完后提示

重啟mysql時提示，后臺登陸不了。

解決辦法

vi /www/wdlinux/init.d/mysqld
修改46 47行的目錄為安裝目錄與數(shù)據(jù)庫目錄

圖片附件: 1.png (2013-4-3 10:51, 5.36 KB) / 下載次數(shù) 15871
http://cd-genova.com/bbs/attachment.php?aid=2726&k=f76f0f8b4901de99571844b9c5bcfea9&t=1743907723&sid=h06P6b

圖片附件: 2.png (2013-4-3 10:51, 5.27 KB) / 下載次數(shù) 15947
http://cd-genova.com/bbs/attachment.php?aid=2727&k=b55052a5f890ac3a257c570c0e724072&t=1743907723&sid=h06P6b

圖片附件: 3.png (2013-4-3 10:54, 1.1 KB) / 下載次數(shù) 15916
http://cd-genova.com/bbs/attachment.php?aid=2728&k=3dcfe3caf3eb78e99e16ecfeb6dfe60b&t=1743907723&sid=h06P6b

圖片附件: 4.png (2013-4-3 10:54, 18.5 KB) / 下載次數(shù) 15931
http://cd-genova.com/bbs/attachment.php?aid=2729&k=92dc0bfded0c8ac2a005cb877932ab06&t=1743907723&sid=h06P6b

圖片附件: 5.png (2013-4-3 10:54, 8.81 KB) / 下載次數(shù) 16039
http://cd-genova.com/bbs/attachment.php?aid=2730&k=fba3f8faab2f7b5403307a311fd1c27d&t=1743907723&sid=h06P6b

作者: benroo 時間: 2013-5-31 00:11

謝謝解決問題

作者: danceboy 時間: 2013-9-11 21:18

謝謝，OK了

作者: kideny 時間: 2014-1-8 03:01

我靠，這個帖子應(yīng)該加精華。

作者: 390836847 時間: 2014-1-22 01:08

這個可以找admin。。。

admin少些的東西，我們集體到admin 家賴著。。。

作者: alongdj 時間: 2014-2-14 23:36

謝謝解決問題~~!

作者: allengreen 時間: 2014-3-26 02:31

這個證明了，有效�。。。�！
非常非常感謝

作者: crsfly 時間: 2014-4-12 17:20

我的無效，怎么搞得？

作者: crsfly 時間: 2014-4-12 17:25

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 submitting a bug report
at http://bugs.mysql.com/

ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/www/wdlinux/mysql-5.5.36/data/AY140224145940Z.pid).

Running..., Please Wait...
err
mysql update is OK
[root@AY140224145940Z ~]#

作者: crsfly 時間: 2014-4-12 17:26

無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確!:

作者: allenyi 時間: 2014-4-14 05:57

給力謝謝

作者: q清和 時間: 2014-4-30 21:36

和11樓一樣沒解決

作者: abu3d 時間: 2014-5-28 11:05

不會操作，能詳細(xì)點(diǎn)教程不？

作者: millkiss 時間: 2014-5-30 20:55

回復(fù) 12# q清和

我這邊的解決方案可以參考下 http://cd-genova.com/bbs/viewthread.php?tid=10582&extra=

作者: nuxgod 時間: 2014-7-31 18:05

謝謝不錯謝謝不錯謝謝不錯謝謝不錯

作者: ucyo123 時間: 2014-12-7 10:24

就是用此方法解決，謝謝。

作者: flying 時間: 2015-2-2 14:29

我來頂貼，只為讓更多的人看到這個好貼。感謝樓主

作者: 朗朗 時間: 2015-3-13 19:20

謝謝不錯支持支持,找了半天終于搞定

作者: skyccp 時間: 2015-4-9 14:47

RE: MYSQL5.5+php5.4+zend guard升級方法

作者: ganjiajin 時間: 2015-4-27 16:06

謝謝不錯謝謝不錯謝謝不錯謝謝不錯

作者: 906475828 時間: 2015-4-28 11:01

my.cnf 還需要777權(quán)限才能啟動

作者: wzhlrch 時間: 2015-5-15 23:57

感謝分享，我的問題解決了

作者: huangcheng101 時間: 2015-5-24 12:36

我要收藏的噠。為什么沒有收藏到��！

作者: 66eagle 時間: 2015-5-26 12:22

我給了667 要找一下是不是，啟動時用了哪個用戶。他沒有權(quán)限運(yùn)行。

作者: 愚小米 時間: 2015-6-17 18:18

這個證明了，有效�。。。�！
非常非常感謝

作者: laosun 時間: 2015-8-1 01:40

拖拖的表示不錯...

作者: lovon 時間: 2015-10-27 10:15

Filling help tables...
OK

作者: hionline 時間: 2015-12-17 16:24

感謝，升級成功了

歡迎光臨 WDlinux官方論壇 (http://cd-genova.com/bbs/)