吻你不叼烟 发表于 2019-6-2 12:10:18

1.6版本升级mysql 8.0.16失败

默认mysql是8.0.13版本

日志:

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

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

============================check files==================================
mysql-boost-8.0.16.tar.gz
============================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...
Stoping nginx...done
Shutting down MySQL.. SUCCESS!
Gracefully shutting down php-fpm . done
Starting upgrade MySQL...
Uncompress mysql-boost-8.0.16.tar.gz...
cd mysql-8.0.16...
[+] Download or use exist boost...
-- Running cmake version 2.8.12.2
CMake Warning at CMakeLists.txt:43 (MESSAGE):
Please use cmake3 rather than cmake on this platform


-- Please install cmake3 (yum install cmake3)
CMake Error at CMakeLists.txt:55 (CMAKE_MINIMUM_REQUIRED):
CMake 3.4.3 or higher is required.You are running version 2.8.12.2


-- Configuring incomplete, errors occurred!
make: *** No targets specified and no makefile found.Stop.
make: *** No targets specified and no makefile found.Stop.
make: *** No rule to make target `install'.Stop.
groupadd: group 'mysql' already exists
useradd: user 'mysql' already exists
include/upgrade_mysql.sh: line 532: /usr/local/mysql/bin/mysqld: No such file or directory
cp: cannot stat ‘/root/lnmp1.6/src/mysql-8.0.16/support-files/mysql.server’: No such file or directory
chmod: cannot access ‘/etc/init.d/mysql’: No such file or directory
Failed to execute operation: No such file or directory
include/mysql.sh: line 39: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 47: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 50: /usr/local/mysql/bin/mysqladmin: No such file or directory
failed, try other way...
include/mysql.sh: line 53: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 63: /usr/local/mysql/bin/mysql: No such file or directory
Set password failed!
include/mysql.sh: line 73: /etc/init.d/mysql: No such file or directory
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
Update root password...
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove anonymous users...
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Disallow root login remotely...
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove test database...
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Reload privilege tables...
include/main.sh: line 684: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
include/mysql.sh: line 103: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 104: /etc/init.d/mysql: No such file or directory
include/upgrade_mysql.sh: line 553: /etc/init.d/mysql: No such file or directory
Restore backup databases...
include/upgrade_mysql.sh: line 556: /usr/local/mysql/bin/mysql: No such file or directory
Repair databases...
include/upgrade_mysql.sh: line 558: /usr/local/mysql/bin/mysql_upgrade: No such file or directory
include/upgrade_mysql.sh: line 560: /etc/init.d/mysql: No such file or directory
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|            https://lnmp.org             |
+-------------------------------------------+
Starting LNMP...
Starting nginx...done
/bin/lnmp: line 26: /etc/init.d/mysql: No such file or directory
Starting php-fpmdone
======== upgrade MySQL failed ======
upgrade MySQL log: /root/upgrade_mysql.log
You upload upgrade_mysql.log to LNMP Forum for help.


licess 发表于 2019-6-2 15:14:10

CMake 3.4.3 or higher is required.You are running version 2.8.12.2
上面已经有明确提示,你这centos 6的肯定是万万不行的
mysql 8.0.13+版本之后对系统cmake、gcc之类的要求都很高,除非是最最新的系统且内存足够大才去升级mysql 8.0.13以后的版本
页: [1]
查看完整版本: 1.6版本升级mysql 8.0.16失败