WDlinux官方论坛 » lamp|lnmp|lnamp|一键安装包 » 关于mysql升级到5.5报错问题

happyboy 发表于 2013-4-3 10:56

关于mysql升级到5.5报错问题

升级命令wget http://down.wdlinux.cn/in/[b][color=#FF0000]mysql[/color][/b]_up55.sh
sh [b][color=#FF0000]mysql[/color][/b]_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://www.wdlinux.cn/bbs/viewthread.php?tid=5137
安装完后提示
[attach]2726[/attach]

重启mysql时提示，后台登陆不了。
[attach]2727[/attach]

解决办法

[attach]2728[/attach]

vi /www/wdlinux/init.d/mysqld
修改46 47行的目录为安装目录与数据库目录
[attach]2729[/attach]



[attach]2730[/attach]

benroo 发表于 2013-5-31 00:11

谢谢 解决问题

danceboy 发表于 2013-9-11 21:18

谢谢，OK了

kideny 发表于 2014-1-8 03:01

我靠，这个帖子应该加精华。

390836847 发表于 2014-1-22 01:08

:lol

这个可以找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是否已启动及用户密码是否设置正确!:

allenyi 发表于 2014-4-14 05:57

给力 谢谢:)

q清和 发表于 2014-4-30 21:36

和11楼一样 没解决

abu3d 发表于 2014-5-28 11:05

不会操作，能详细点教程不？

millkiss 发表于 2014-5-30 20:55

[b]回复 [url=http://www.wdlinux.cn/bbs/redirect.php?goto=findpost&pid=36268&ptid=5461]12#[/url] [i]q清和[/i] [/b]


     我这边的解决方案 可以参考下 [url=http://www.wdlinux.cn/bbs/viewthread.php?tid=10582&extra=]http://www.wdlinux.cn/bbs/viewthread.php?tid=10582&extra=[/url]

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权限才能启动

wzhlrch 发表于 2015-5-15 23:57

感谢分享，我的问题解决了

huangcheng101 发表于 2015-5-24 12:36

我要收藏的哒。 为什么没有收藏到！！

66eagle 发表于 2015-5-26 12:22

我给了667 要找一下是不是，启动时用了哪个用户。 他没有权限运行。

愚小米 发表于 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

感谢，升级成功了

查看完整版本: 关于mysql升级到5.5报错问题