leedow 发表于 2023-11-8 14:39:15

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

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 : 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
OpenSSL 1.0.2k-fips26 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.


leedow 发表于 2023-11-8 14:39:49

lnmp是2.0版本,服务器上只安装了mysql

licess 发表于 2023-11-20 08:31:49

没有适配过的版本肯定是无法进行升级的
页: [1]
查看完整版本: 使用./updgrade.sh脚本升级mysql失败