1
2
3
4
5
yum install ncurses-devel -y
yum install rpcgen -y
wget https://downloads.mysql.com/archives/get/file/mysql-boost-5.7.23.tar.gz
tar zxvf mysql-boost-5.7.23.tar.gz
cd mysql-5.7.23/

1
2
rm -rf CMakeCache.txt
yum install ncurses-devel

1
2
rm -rf CMakeCache.txt
yum install rpcgen

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
-- Running cmake version 3.12.1
-- Configuring with MAX_INDEXES = 64U
-- CMAKE_GENERATOR: Unix Makefiles
-- SIZEOF_VOIDP 8
-- MySQL 5.7.23
-- Packaging as: mysql-5.7.23-Linux-aarch64
-- Local boost dir /home/geostar/geoglobe/mysql/mysql-5.7.23/boost/boost_1_59_0
-- Found /home/geostar/geoglobe/mysql/mysql-5.7.23/boost/boost_1_59_0/boost/version.hpp
-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 105900
-- BOOST_INCLUDE_DIR /home/geostar/geoglobe/mysql/mysql-5.7.23/boost/boost_1_59_0
-- NUMA library missing or required version not available
-- WITH_PROTOBUF=bundled
-- protobuf version is 2.6
-- You need to set WITH_CURL. This variable needs to point to curl library.
-- Creating LDAP authentication SASL client library.
-- Required SASL library is missing. Skipping the LDAP SASL client authentication plugin.
-- Library mysqlclient depends on OSLIBS -lpthread;m;rt;atomic;dl
-- MERGE_CONVENIENCE_LIBRARIES TARGET mysqlclient
-- MERGE_CONVENIENCE_LIBRARIES LIBS clientlib;dbug;strings;vio;mysys;mysys_ssl;zlib;yassl;taocrypt;dl
-- MERGE_CONVENIENCE_LIBRARIES MYLIBS clientlib;dbug;strings;vio;mysys;mysys_ssl;zlib;yassl;taocrypt
CMake Error at rapid/plugin/group_replication/rpcgen.cmake:97 (MESSAGE):
Could not find rpc/rpc.h in /usr/include or /usr/include/tirpc
Call Stack (most recent call first):
rapid/plugin/group_replication/CMakeLists.txt:29 (INCLUDE)
-- Configuring incomplete, errors occurred!
See also "/home/geostar/geoglobe/mysql/mysql-5.7.23/CMakeFiles/CMakeOutput.log".
See also "/home/geostar/geoglobe/mysql/mysql-5.7.23/CMakeFiles/CMakeError.log".

1
2
3
4
5
2019-08-20T09:11:10.268167Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-20T09:11:10.442029Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-08-20T09:11:10.702832Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 739a0904-c32a-11e9-8108-fa163e8a366b.
2019-08-20T09:11:10.706663Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-08-20T09:11:10.707259Z 1 [Note] A temporary password is generated for root@localhost: 9cC5ycy(phS,

1
2
cd /usr/local/mysql/support-files
./mysql.server start

1
2
3
4
5
cd /usr/local/mysql/bin
./mysqld_safe --skip-grant-tables
use mysql
update user set password=password("你想要的密码") where user="root";
flush privileges;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
mysql> use mysql;
Database changed
mysql> select User from user;
#此处为查询用户命令
+-----------+
| User
|
+-----------+
| *******
|
| mysql.sys |
| root
|
+-----------+
3 rows in set (0.00 sec)
mysql> update user set password=password("*******") where user="*******";
#修改密码报错
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql> update mysql.user set authentication_string=password('*******') where user='*******';
#修改密码成功
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1
Changed: 1
Warnings: 1
mysql> flush privileges;
#立即生效
Query OK, 0 rows affected (0.00 sec)