升级mysql 8.0.13 出错

crazyfd

你好，升级mysql 8.0.13 出错，系统centos7.5 ，内存8G
详细日志
-- Configuring incomplete, errors occurred!
See also "/root/lnmp1.5/src/mysql-8.0.13/CMakeFiles/CMakeOutput.log".
See also "/root/lnmp1.5/src/mysql-8.0.13/CMakeFiles/CMakeError.log".
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 531: /usr/local/mysql/bin/mysqld: No such file or directory
chgrp: cannot access ‘/usr/local/mysql/.’: No such file or directory
cp: cannot stat ‘/root/lnmp1.5/src/mysql-8.0.13/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 667: /usr/local/mysql/bin/mysql: No such file or directory
Update root password...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove anonymous users...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Disallow root login remotely...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove test database...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Reload privilege tables...
include/main.sh: line 667: /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 552: /etc/init.d/mysql: No such file or directory
Restore backup databases...
include/upgrade_mysql.sh: line 555: /usr/local/mysql/bin/mysql: No such file or directory
Repair databases...
include/upgrade_mysql.sh: line 557: /usr/local/mysql/bin/mysql_upgrade: No such file or directory
include/upgrade_mysql.sh: line 559: /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-fpm  done
======== upgrade MySQL failed ======
upgrade MySQL log: /root/upgrade_mysql.log

[ 本帖最后由 crazyfd 于 2018-11-20 11:27 编辑 ]

crazyfd

Stoping LNMP...
Stoping nginx...  done
Shutting down MySQL..[  OK  ]
Gracefully shutting down php-fpm . done
[+] Installing boost_1_59_0
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package python-devel-2.7.5-69.el7_5.x86_64 already installed and latest version
Nothing to do
boost_1_66_0.tar.bz2 [found]
Uncompress boost_1_66_0.tar.bz2...
cd boost_1_66_0...
Starting upgrade MySQL...
Uncompress mysql-8.0.13.tar.gz...
cd mysql-8.0.13...
-- Running cmake version 2.8.12.2
-- Found Git: /bin/git (found version "1.8.3.1")
-- This is Linux version 3.10.0-862.14.4.el7.x86_64
-- We probably need some devtoolset compiler
CMake Warning at CMakeLists.txt:178 (MESSAGE):
  Could not find devtoolset gcc


-- MySQL 8.0.13
-- The C compiler identification is GNU 4.8.5
-- The CXX compiler identification is GNU 4.8.5
-- Check for working C compiler: /bin/cc
-- Check for working C compiler: /bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /bin/c++
-- Check for working CXX compiler: /bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- CMAKE_GENERATOR: Unix Makefiles
-- Looking for SHM_HUGETLB
-- Looking for SHM_HUGETLB - found
-- Looking for sys/types.h
-- Looking for sys/types.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Looking for stddef.h
-- Looking for stddef.h - found
-- Check size of void *
-- Check size of void * - done
-- SIZEOF_VOIDP 8
-- Performing Test HAVE_NOT_C_BUG_LOOP_VECTORIZE
-- Performing Test HAVE_NOT_C_BUG_LOOP_VECTORIZE - Success
-- Performing Test HAVE_NOT_CXX_BUG_LOOP_VECTORIZE
-- Performing Test HAVE_NOT_CXX_BUG_LOOP_VECTORIZE - Success
-- Performing Test HAVE_NOT_C_SHIFT_OR_OPTIMIZATION_BUG
-- Performing Test HAVE_NOT_C_SHIFT_OR_OPTIMIZATION_BUG - Success
-- Performing Test HAVE_NOT_CXX_SHIFT_OR_OPTIMIZATION_BUG
-- Performing Test HAVE_NOT_CXX_SHIFT_OR_OPTIMIZATION_BUG - Success
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD - Failed
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD - Failed
-- Packaging as: mysql-8.0.13-Linux-x86_64
-- Performing Test C_LD_GOLD_RESULT
-- Performing Test C_LD_GOLD_RESULT - Success
-- Performing Test CXX_LD_GOLD_RESULT
-- Performing Test CXX_LD_GOLD_RESULT - Success
-- Local boost dir /root/lnmp1.5/src/boost_1_66_0
-- Found /root/lnmp1.5/src/boost_1_66_0/boost/version.hpp
-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 106600
CMake Warning at cmake/boost.cmake:286 (MESSAGE):
  Boost minor version found is 66 we need 67
Call Stack (most recent call first):
  CMakeLists.txt:739 (INCLUDE)


-- BOOST_INCLUDE_DIR /root/lnmp1.5/src/boost_1_66_0
-- LOCAL_BOOST_DIR /root/lnmp1.5/src/boost_1_66_0
-- LOCAL_BOOST_ZIP LOCAL_BOOST_ZIP-NOTFOUND
-- Could not find (the correct version of) boost.
-- MySQL currently requires boost_1_67_0

CMake Error at cmake/boost.cmake:101 (MESSAGE):
  You can download it with -DDOWNLOAD_BOOST=1 -DWITH_BOOST=<directory>

  This CMake script will look for boost in <directory>.  If it is not there,
  it will download and unpack it (in that directory) for you.

  If you are inside a firewall, you may need to use an https proxy:

  export https_proxy=http://example.com:80

Call Stack (most recent call first):
  cmake/boost.cmake:289 (COULD_NOT_FIND_BOOST)
  CMakeLists.txt:739 (INCLUDE)

-- Configuring incomplete, errors occurred!
See also "/root/lnmp1.5/src/mysql-8.0.13/CMakeFiles/CMakeOutput.log".
See also "/root/lnmp1.5/src/mysql-8.0.13/CMakeFiles/CMakeError.log".
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 531: /usr/local/mysql/bin/mysqld: No such file or directory
chgrp: cannot access ‘/usr/local/mysql/.’: No such file or directory
cp: cannot stat ‘/root/lnmp1.5/src/mysql-8.0.13/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 667: /usr/local/mysql/bin/mysql: No such file or directory
Update root password...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove anonymous users...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Disallow root login remotely...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove test database...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Reload privilege tables...
include/main.sh: line 667: /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 552: /etc/init.d/mysql: No such file or directory
Restore backup databases...
include/upgrade_mysql.sh: line 555: /usr/local/mysql/bin/mysql: No such file or directory
Repair databases...
include/upgrade_mysql.sh: line 557: /usr/local/mysql/bin/mysql_upgrade: No such file or directory
include/upgrade_mysql.sh: line 559: /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-fpm  done
======== upgrade MySQL failed ======
upgrade MySQL log: /root/upgrade_mysql.log

licess

mysql 8.0各个版本对boost的版本要求都不一样，8.0.13的话要求是 boost_1_67_0
这个需要你自己修改include/version.sh 将 Boost_New_Ver='boost_1_66_0' 一行改成 Boost_New_Ver='boost_1_67_0' 并自行去官网下载好 boost_1_67_0.tar.bz2 到lnmp安装包 src 目录下
方法2：修改include/upgrade_mysql.sh 查到 -DWITH_BOOST=${cur_dir}/src/${Boost_New_Ver} 全部替换为 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=${cur_dir}/src
保存
然后再进行升级操作