[教程] 关于mysql升级到5.5报错问题

happyboy

升级命令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://www.wdlinux.cn/bbs/viewthread.php?tid=5137
安装完后提示

下载 (5.36 KB)

2013-4-3 10:51

重启mysql时提示，后台登陆不了。

下载 (5.27 KB)

2013-4-3 10:51

解决办法

下载 (1.1 KB)

2013-4-3 10:54

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

下载 (18.5 KB)

2013-4-3 10:54

下载 (8.81 KB)

2013-4-3 10:54

benroo

谢谢 解决问题

danceboy

谢谢，OK了

kideny

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

390836847

这个可以找admin。。。


admin少些的东西，我们集体到admin 家赖着。。。

alongdj

谢谢 解决问题~~!

allengreen

这个证明了，有效！！！！！
非常非常感谢

crsfly

我的无效，怎么搞得？

crsfly

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

无法连接mysql，请检查mysql是否已启动及用户密码是否设置正确!:

allenyi

给力 谢谢

q清和

和11楼一样 没解决

abu3d

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

millkiss

回复 12# q清和


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

nuxgod

谢谢不错谢谢不错谢谢不错谢谢不错