博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
关于mysql升级到5.5报错问题
阅读量:4198 次
发布时间:2019-05-26

本文共 1912 字,大约阅读时间需要 6 分钟。

关于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 ; perlmysql-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
安装完后提示
1.png
重启mysql时提示,后台登陆不了。
2.png
解决办法
3.png
vi /www/wdlinux/init.d/mysqld
修改46 47行的目录为安装目录与数据库目录
4.png
5.png

转载地址:http://bhbli.baihongyu.com/

你可能感兴趣的文章
接口内存模型
查看>>
C# TextBox中的Validating与Validated事件
查看>>
关于Platform SDK和Windows SDK
查看>>
初始化列表
查看>>
条款15:让operator=返回*this的引用
查看>>
装箱和拆箱数据类型转换
查看>>
MFC 消息映射的工作方式
查看>>
MFC项目Unicode版本程序入口
查看>>
精典FormsAuthenticationTicket分析
查看>>
asp.net form验证
查看>>
VS2008中安装ASP.NET MVC2后无法新建工程的解决方法
查看>>
SQL Server 标识列
查看>>
SQL WITH TIES
查看>>
ASP.NET调用存储过程并接收存储过程返回值
查看>>
Debian: Driver 'pcspkr' is already registered, aborting
查看>>
Samba
查看>>
JavaScript原型和继承
查看>>
passdb backend = tdbsam
查看>>
Samba配置文件常用参数
查看>>
debian安装mongodb
查看>>