VPS侦探论坛

 找回密码
 注册
查看: 556|回复: 2

使用./updgrade.sh脚本升级mysql失败

[复制链接]
发表于 2023-11-8 14:39:15 | 显示全部楼层 |阅读模式

mysql 8.0.3升级到8.20失败,麻烦大佬们看下


Enter current root password of Database (Password will not shown): OK, MySQL root password correct.
Current MYSQL Version:8.0.33
You can get version number from http://dev.mysql.com/downloads/mysql/
Please input MySQL Version you want.
(example: 5.5.60 ): Using Generic Binaries [y/n]: Default install MySQL 8.2.0 Using Generic Binaries.
===========================
Do you want to install the InnoDB Storage Engine?
(Default yes,if you want please enter: y , if not please enter: n): No input, The InnoDB Storage Engine will enable.
==================================================
You will upgrade MySQL Version to 8.2.0
==================================================

Press any key to start...or Press Ctrl+c to cancel

============================check files==================================
mysql-8.2.0.tar.gz [found]
OpenSSL 1.0.2k-fips  26 Jan 2017
============================check files==================================
Starting backup all databases...
If the database is large, the backup time will be longer.
MySQL databases backup successfully.
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              https://lnmp.org             |
+-------------------------------------------+
Stoping LNMP...
/usr/bin/lnmp: line 42: /etc/init.d/nginx: No such file or directory
Shutting down MySQL.. SUCCESS!
/usr/bin/lnmp: line 44: /etc/init.d/php-fpm: No such file or directory
chgrp: cannot access ‘/usr/local/mysql/.’: No such file or directory
cp: cannot stat ‘/usr/local/mysql/support-files/mysql.server’: No such file or directory
chmod: cannot access ‘/etc/init.d/mysql’: No such file or directory
include/mysql.sh: line 33: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 41: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 44: /usr/local/mysql/bin/mysqladmin: No such file or directory
failed, try other way...
include/mysql.sh: line 47: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 60: /usr/local/mysql/bin/mysql: No such file or directory
Set password failed!
include/mysql.sh: line 62: /usr/local/mysql/bin/mysql: No such file or directory
FLUSH PRIVILEGES failed!
include/mysql.sh: line 67: /etc/init.d/mysql: No such file or directory
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
Update root password...
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove anonymous users...
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Disallow root login remotely...
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove test database...
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Reload privilege tables...
include/main.sh: line 1027: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
include/mysql.sh: line 97: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 98: /etc/init.d/mysql: No such file or directory
include/upgrade_mysql.sh: line 612: /etc/init.d/mysql: No such file or directory
Restore backup databases...
include/upgrade_mysql.sh: line 615: /usr/local/mysql/bin/mysql: No such file or directory
Repair databases...
include/upgrade_mysql.sh: line 619: /etc/init.d/mysql: No such file or directory
Upgring MySQL...
Waiting for upgrade to start...
include/upgrade_mysql.sh: line 621: /usr/local/mysql/bin/mysqld: No such file or directory
include/upgrade_mysql.sh: line 624: /usr/local/mysql/bin/mysqladmin: No such file or directory
include/upgrade_mysql.sh: line 629: /etc/init.d/mysql: No such file or directory
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              https://lnmp.org             |
+-------------------------------------------+
Starting LNMP...
/usr/bin/lnmp: line 28: /etc/init.d/nginx: No such file or directory
/usr/bin/lnmp: line 29: /etc/init.d/mysql: No such file or directory
/usr/bin/lnmp: line 30: /etc/init.d/php-fpm: No such file or directory
======== upgrade MySQL failed ======
upgrade MySQL log: /root/upgrade_mysq20231108141319.log
You upload upgrade_mysq20231108141319.log to LNMP Forum for help.


美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2023-11-8 14:39:49 | 显示全部楼层


lnmp是2.0版本,服务器上只安装了mysql
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
发表于 2023-11-20 08:31:49 | 显示全部楼层

没有适配过的版本肯定是无法进行升级的
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-5-4 11:57 , Processed in 0.025822 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表